comparing dates in ASP.

i am creating a webpage for keeping tracks of new hires.
in my database we keep track of the day they start (

Code:

---

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

Code:

---

WHERE DateDiff(""d"", start_date, " & date() & ")"

---

within my SQL Query, but it was not successful... anyone have a better idea?

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

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