I created a field of type Date/Time using Visual Data Manager
I am not able to use select statement with where clause like this,

recordset.open "select * from tablename where datefield>'" & DTpicker1.value & "'",db, db, adOpenStatic, adLockOptimistic

how do I check date/time values in a table using the DTpicker controls in a form

I want to select orders make between given two dates

Warm Ragards
Kavitha