Date Field Not Sorting Chronologically
There may be an obvious solution here, but for some reason when trying to sort my records in table view by a date field the order coming up is not chronological at all. Attached is a screenshot of the wacky sort I am getting when done by date (descending). The field is set up as a Date field, and I can't figure out any other reason why the sort would be coming out this way so any help would be appreciated. Thanks!