Closed dbenn closed 1 year ago
I'm sure I've noticed this in the past but have failed to document it in an issue.
One approach here is to do something I've thought about for quite awhile which is to convert that column to ISO 8601 format, which would order naturally without change to the sorting method, and in any case, is the only real sane date format.
@BradWalter said this in the July 2022 VStar CHOICE course: When you sort by the calendar date column the records do not sort in ascending or descending order. The field is sorted in in alphanumeric (i.e. text) order. For the TZ Boo Data in the Week 1 Section III Part A exercise, if you click on the column to sort in ascending calendar . They are in alphabetical order within their year. For example, the 1997 Jun entries appear before the 1997 May entries. I don't think that is the intended sorting order. Years and and days within a month are in correct chronological order. Times within a day also appear to be in correct order, However months within a year are not in chronological order. Hmmmmm? I suspect this idiosyncrasy has already been noted.