2 Replies Latest reply on Jan 31, 2011 2:48 PM by philmodjunk

    find by date in ess mysql table



      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?