Good Day all,
I am trying to sort the values in a field in a table, however only some of the values are sorted as expected.
The data type for the field is Date/Time and the property is medium time.
Here are the results for two officers in the same field, all sorted in ascending order:
can any one assist in explaining the difference.
Time Entered by Officer 7:59 AM 2:43 PM 3:43 PM 4:32 PM
Time Entered by Officer 8:00 AM 1:12 PM 2:11 PM 4:46 PM