Dates and unrestrained data

[teash]

Hello everyone,

SELECT * FROM Orders WHERE (OrderDue>#8/8/2006#);

This SQL statement should give me a list of all the orders that are due in the next few weeks but not the ones that were handled yesterday or in the weeks before.

I inheritied this aweful but functional ASP/Access ordering system. My "OrderDue" column contains all types of data.

For Example:

4/13/06
4-21-06
CANCELED
4/14/06
4/13/06
6-1-06
PENDING
06/12/06
4/7/06
4/12/06
PENDING
4/12/06


My question is, am I wasting my time trying to finding the proper SQL syntax or will I get an error or invalid data.
The SQL function above works, it gives me 300 or so results out of the 2000 records. However all 300 results are not greater than #8/8/06#.

My other option is to query all the data into an array and let the ASP do the work to filter the proper dates. But I think this would be cumbersome.

 

[Golom]

You could modify the SQL to process only those records that have a valid date

SELECT * 

FROM Orders 

WHERE IsDate(OrderDue) AND (cDate(OrderDue)>#8/8/2006#);