Hey Guys. I really hope someone can help me here as I am ready to pull my hair out. This is driving me totally nuts.

Why can't I get any records returned when I compare a date field in my database to a date formated variable in my asp script. For instance, assume the field "AppointDate" = 2/19/2002.

The following is just for the sake of argument.
CalDate = formatDateTime(Date(), 2)

The line above should return a variable that equals "02/19/2002"
If I just used the "Date()" function by itself, the function would return the same exact date "02/19/2002."

The following SQL statement returns nothing.
SQL = "SELECT Count(*) As AppDate From Guests WHERE AppointDate = " & CalDate

The following SQL statement returns the correct count.
SQL = "SELECT Count(*) As AppDate From Guests WHERE AppointDate = Date()"

In my script, the variable "CalDate" holds different dates that change within a loop command, which is why I can't just use the "Date()" command with my SQL statement. Maybe I am just stupid or something, but can you use a variable formated as a date with in an SQL statement, or just the "Date()" or "Now()" functions? What gives?