AnsweredAssumed Answered

Can't search by date

Question asked by ClarkeHill on Aug 17, 2013
Latest reply on Aug 18, 2013 by philmodjunk

Title

Can't search by date

Post

     I create my database by exporting data from another application into a CSV formatted text file. Filemaker creates a DB out of that just fine, with all the fields as text fields. The field I want to search on is a date field formatted like "2013-08-14 16:00:12 +0000".

     Search for all dates less than that date while it is still a text field, such as "< 2013-08-15 15:15:45 +0000" doesn't work. 

Converting it to a date field and searching gives me "no records match this criteria" when obviously many do.

Converting it to a timestamp field and searching gives me "no records match this criteria" when obviously many do.

     If I convert it to date or timestamp it refuses to sort properly. No matter what I do, the records stay sorted in the order of another field, which is labeled "Created" from the csv file.

     How can I sort by date in these databases?

Outcomes