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!
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.