Actually, I had posted the reply to a similar question somewhere else, might as well repeat myself.

CoMMiE, what you need to do is: convert strDate to a format, say 'mm/dd/yyyy' using the Format() function. Then in your query, convert the date field into the same format using the SQL date functions. I don't have any experience working with SQL, so I shall quote Oracle example:

Select * from Customers where TO_CHAR(BirthDate, 'mm/dd/yyyy') = '" & Format(MyDate, "mm/dd/yyyy") & "'"
See if it works.

By the way, you haven't answered my question, I think. Are you non-US ?