AnsweredAssumed Answered

find by date in ess mysql table

Question asked by RCSchroeder on Jan 31, 2011
Latest reply on Jan 31, 2011 by philmodjunk

Title

find by date in ess mysql table

Post

Using the find how does one format the date to select a date or range of dates?

The mysql date,  2011-02-21 (for example) and the Filemaker date is 2/21/2011 for the same date. If I query for all records it displays in the FileMaker date format, but if I try to find specific dates or date ranges, it tells me that the mysql format is invalid and gives me an example of the Filemaker format, which, when I use that does not return any records.

 

I want to retrieve rows that have a certain date match or range of dates. Can anyone tell me how to do this?

Outcomes