odbc error syntax

[neitan]

Hello! I'm use FileMaker 12 PRO Ad for access to filemaker base throughout ODBC.
When i use query

Select * from Invoices WHERE Date>'2013-03-15'

I get error message 
(Microsoft OLE DB Provider for ODBC Drivers): [FileMaker][FileMaker] FQL0001/(1:30): There is an error in the syntax of the query.
How use "Date" in query?

Thanks!

 

[jbante]

I believe "Date" may be a reserved word or function in FQL. If "Date" is also the name of the field you're targeting, perhaps try wrapping it in quotes:

SELECT * FROM "Invoices" WHERE "Date" > '2013-03-15'