Sending a date parameter in a sql string call

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am selecting a table called Holiday and I need to loop thru 'x' amount of
days to see if days fall on any holidays. There is a holiday but the sql
statement I am running doesn't find it. It returns no records when there IS
at least one.

I know it has to do with the " " again but I can't figure this out. Any
help is appreciated!!!! :)

Here is the code:
strSQL = "SELECT Holiday.* FROM Holiday WHERE Holiday.HolidayDate = " &
dCheckDate

Thanks!

Janis in Minne-SNOW-ta
 
You need to surround the dCheckDate with date delimiters (# signs)

strSQL = "SELECT Holiday.* FROM Holiday WHERE Holiday.HolidayDate = #" &
dCheckDate & "#"
 
And if your Short Date format (in Regional Settings in the Control Panel)
isn't mm/dd/yyyy, you could run into problems.

To prevent problems, I'd suggest

strSQL = "SELECT Holiday.* FROM Holiday " & _
"WHERE Holiday.HolidayDate = " & _
Format(dCheckDate, "\#mm\/dd\/yyyy\#")
 
Thanks - I will make sure! :)

Douglas J Steele said:
And if your Short Date format (in Regional Settings in the Control Panel)
isn't mm/dd/yyyy, you could run into problems.

To prevent problems, I'd suggest

strSQL = "SELECT Holiday.* FROM Holiday " & _
"WHERE Holiday.HolidayDate = " & _
Format(dCheckDate, "\#mm\/dd\/yyyy\#")
Click to expand...
 
Back
Top