I'm using FileMaker Pro 9 with JDBC, and I'm trying to get all records in a table where the date is greater than (or less than) any given date.
Here's the SQL command string I'm trying to use:
SELECT * FROM Reservations WHERE 'date' > {D'2009-11-14'}
I have played around with a variety of other date formats, also, and I either get an error, or it returns every single record in the database. I also am unable to pull all records where the date MATCHES some date value.
Any help would be greatly appreciated.
Thanks!
-- Scott