TechnoWeenie
MIS
I'm trying to find all items in my db that are active and where the expire_date is either today's date or in the future and then sort them by category.
Finding anything that is active and sorting by category works fine. It's the date part that isn't wokring for me. The format of the date is MM/DD/YYYY
Here is query
SELECT * FROM Items WHERE active=True AND expire_date>=" & Date & " ORDER BY category
I'm using this in a Active Server Page. That is why there is the " & Date & " in the statement.
So what am i missing?
Finding anything that is active and sorting by category works fine. It's the date part that isn't wokring for me. The format of the date is MM/DD/YYYY
Here is query
SELECT * FROM Items WHERE active=True AND expire_date>=" & Date & " ORDER BY category
I'm using this in a Active Server Page. That is why there is the " & Date & " in the statement.
So what am i missing?