I have about 650 records imported into a date field showing YYYY-MM-DD
When I add a new record it's entered MM/DD/YYYY
When I sort the Date Field the records the data doesn't sort the - and / date fields.
I've set a filter to invalid dates
I've backed up and tried a "Replace Field Contents" on the filter using GetAsDate(Date) and the results now show a ? in the date field.
(Date is the field name)
Thanks in advance
Using FMP 16