I have a simple qn that has dumbfounded me and have not been able to find any solutions.
I create a Date field in my SQL database and have records in it. I use ADODB connection to connect to my VB program.
But this simple SQL statement refuses to work rs.Open "Select * from Testing Where Date = 03/05/2006"
Alternatives that I have tried include:-
1) putting single quotes around the date like '03/05/2006' but to no success.
2) testing other fields to know the connection works cos I could get results from them.
3) Reiterate thro the recordset
Do While Not rs.EOF
i could actually see the date 03/05/2006 appearing
what have I done wrong?