Hi,
I'm writing a problem and I've come across this problem. I have a database table with some records. One of the field is a DateTime field. I want retieve the records that match a specific Date NOT the Date and Time, ONLY the DATE

the code below is what I have, but it doesn't work. How can I solve this?

Code:
tmpSql = "SELECT * FROM schedule WHERE expired_date = #" & Format(TheDate, "mm/dd/yyyy") & "#"

Note the variable TheDate is as Date - example "12/20/2000"