Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access data base datetime query - what datetime format???
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Access data base datetime query - what datetime format???
Miscellaneous
Thread ID:
00813055
Message ID:
00813055
Views:
41
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.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Next
Reply
Map
View

Click here to load this message in the networking platform