> strSQL = "SELECT * " & _
> "FROM mytable " & _
> "WHERE reminddate = strDate"
>...What am I doing wrong? Please help
If you are in the UK, I will also preempt your next question, Q. 'Why
does it get the month and the day mixed up ?'. A. You need to convert
strDate to the US format (see below).
If strDate is a string entered by the user, first convert it to a
date data type:
If IsDate(strDate) then
MsgBox "Unable to interpret the date '" & strDate & "'..."
Then do this:
"WHERE reminddate = #" & format(MyDate,"mm/dd/yyyy") & "#"