I am perplexed as to why there is a Date field type however it can only be sorted by 1-9 which puts the month of October ahead of January. Or another table of mine, it will sort January first for a few records, then start over.
I don't know. Sorting by date seems really basic yet it is not working correctly in any of my tables.
These dates sort fine in FileMaker, Excel, and Google Sheets. I'm stumped.
Anyone have any suggestions? These tables were imported via CSV.