comparing dates in ASP.

[nzerod]

i am creating a webpage for keeping tracks of new hires.
in my database we keep track of the day they start (start_date) any way i was trying to make the asp only list the people who start AFTER the current date.

so i was trying

WHERE DateDiff(""d"", start_date, " & date() & ")" within my SQL Query, but it was not successful... anyone have a better idea?

[Clunietp]

"Select * from MyTable where Start_Date > '" & Date() & "'"

[nzerod]

you would think that would work, however... it fails. it still gives dates that were prior to the current date. pisses me off.