Date Syntax on SQL Anywhere Pass-Through Query 1

[Sumnor]

I have created an Access SQL Anywhere pass-through query that correctly brings back thousands of records. I would like to limit the number of records returned to only those created since 01/01/2003. For some reason I am getting an ODBC Driver Syntax Error regardless of the syntax I use. What is the date where syntax I should use to find all records greater than or equal to 01/01/2003?

Thanks, in advance!

 

[Lothario]

What is the data type of the date field in your database?

-L

 

[mordja]

Sumnor,

What is the destination of the Pass Through(Sybase, SQL Server ?) perhaps you should try Date >= "20030101"

Mordja

 

[Sumnor]

Thanks, Mordja. I was able to apply the date format as you suggested and VOILA the pass-through query worked! Such a simple fix... I wish I had come up with it myself. It certainly pays to ask for help!