SQL syntax for date

[ae_jester]

u need to use # before and after dates in SQL.

ex.

rs.Open "SELECT * FROM tblWhatever WHERE birthDate = #" & txtDate.text & "#"