Return to FileMaker.com
How can I correct sort sequence errors?
In sorting 108 records by modification date (descending), records 1—4 show 3/6/12, records 5—35 show 3/5/12, records 36—59 show 3/13/12, records 60—100 show 3/12/12, records 101—108 show 2/29/12.
I have tried alternately sorting in ascending and descending order, changing field sort order, etc.
I have no clue why it's sorting this way, or what else I can try.
Help, please — LDD
Use Manage | database | Fields to change the data type for the field from text to date. The order you report is correct sorting for the data shown if they are entered in a text field instead of a date field.
Retrieving data ...