>>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.
>
>it should be
>
>Where indate=#1/1/2002#
>
>HTH, Igor

Igor,
thanks. Ceton's method works for mem vars and it looks like yours will work for literals. The more I know the better off I am. By the way, you don't know of any place that has a bunch if Acess SQL examples, do you?

Thanks again,
John.