find by date in ess mysql table
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?