What is wrong in the following Statement?
Dim mydate As Date
Format(mydate, "m/d/yy")
rs.Open "SELECT * from accounts where date='" & mydate & "';", con, adOpenStatic, adLockOptimistic
It gives the Error "Data type mismatch in citerian expression"