>>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 indate > ?mydate
>Cetin

Cetin,
thanks a million, that's what I needed. One more question. Do you know of any place where I can find some helpful hints on running SQLs on Access tables from VFP? I'm new at this but I have to now interface my VFP program with another that is in Access. If I could just find a bunch of examples I would be in great shape. The ODBC is working just fine. I just need some SQL examples.

John.