If you have a sql datetime field that looks like this: "2013-02-14 00:00:00.000", it is hard to query from an asp page unless you get your date formatted in your asp page to be formatted the same as your sql datetime field. There are probably lots of ways to do that.
Here's one approach:
Step 1 - format the current system date in asp to generate a date that looks like: 02/15/2013
Dim today
today = cstr(formatdatetime(now(),2))
If len(today)=9 then
today ="0" + today
End if
Step 2 - format your date in your sql query to also look like: 02/15/2013
convert(char(10),datefieldinsql,101)
Step 3 - ending sql query
"Select * from table where convert(char(10),datefieldinsql,101)='" & today & "'"
Notice that we put a single quote around the today variable.