Date Data Type & SQL

[JorgeLedo]

I tried to make an SQL statement that seached a DB for a single Date but I recived allways an error message for invalid data type. This means I tried this:
Set rst = dbs.OpenRecordset("SELECT * FROM DBaes WHERE date =" & Var_Today)

Where: "DBase" was my database
"date" the field on the database with Date/Time data type
"Var_Today" a variable with today date for comparison (I tried it as Variant, Date and String data type) all of them gave me error.

[Clunietp]

Try this:

"Select * from MyTable where TheDateField = #" & MyStringOrDateVariable & "#"

HTH

Tom