AnsweredAssumed Answered

Imported dates are hyphen and not sorting correctly with newly added records

Question asked by oklord on Jun 26, 2018
Latest reply on Jun 27, 2018 by beverly

Hi All,

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)

 

Thoughts?

Thanks in advance

Using FMP 16

Outcomes