>I am doing ODBC queries on an Access database. Everything works but I don't know how to format my dates in my VFP code in the SQL query. If I want to get all records where indate > mydate (where indate is an Access datetime field and mydate is a my var in the SQL) how do I format mydate? I tried dtoc() and ttoc() with and without the ,1 parameter but no luck.
>
>TIA
>John.

Where mydate=#1/1/2002#

HTH, Igor