Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Now finally in my updated table I am getting the DATE_FLAG Column and before/after values. But some of the values/rows) which should be before say the dates are before 22nd July 2020 are still labelled as after? The rest of the rows are labelled as expected.
So what is wrong? Do I have to specify the date time format? If so how can I ?
I think I figured out the problem, but need some help with that:
The Abbrev Date comparison is comparing the two Character Date strings and that's why when 07/04/2020 10:12:34 AM is converted to 07/4/2020 when compared with 07/22/2020 is giving after instead of before.