SELECT *
FROM Allocate
WHERE (DEL_STATUS <> 'D') AND SHIP_DATE < Now
I am having trouble with the date portion of this SQL statement. After I run the sql statement the result set contains rows with ship dates that are greater than the current date. I only want rows with expired ship dates to display.
Can anyone see what I am doing wrong ?
Thanks... a bunch !!
[RESOLVED]
My system date was set wrong.... Geeze do I feel really stupid now....
