I have a VB6 project that uses VB Data Controls to maintain data in an MS Access database.
I have now switched to MS ADOData Controls so I can connect to different databases.
Pretty much all the original queries work fine except for those involving selecting/filtering by date.
For example, the original query:-
Select * from table where fldEnd > DateValue('" & dteVariable & "')"
works fine with the VB Data Control but gives an ADODC Unknown error [ADO] when I use the ADODC Data Control.
What syntax should I use ?
## Deliverables
A solution that works !
## Platform
win 98 2 and above