I'm having some troubles trying to insert a date into a FileMaker database via SQL. The following is something I'm trying:
INSERT INTO Invoices (CreationDate) VALUES (2/20/2007)
I don't get any parsing errors with this and the data inserts, however, it's doing the math and inserting 2 divided by 20 divided by 2007. Winds up with a crazy decimal like .0002343023403030.
If I try and put single quotes around the date value FM returns a "query failed" error, and nothing more.
Any information on how I can get the SQL query to treat 2/20/2007 as a date value instead of doing the math would be greatly appreciated. Thanks!