-
i am creating a webpage for keeping tracks of new hires.
in my database we keep track of the day they start () 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.