Date Comparision in CFQUERY in Coldfusion
Posted on 2011-10-24
I have a WarhouseDeliveryDate Field (Date/Time Field type in ACCESS) in the table and
This field remains empty until the item is delivivered to the warehouse and then a user enters the date into the field.
I need to come up with the query that satisfies the following condition.
I like to select orders where WarehouseDeliveryDate is either empty (which means the order has not been delivered to the WH yet) or if they have a date filled in, it has to be newer than (today's date - 14).
I have tried a various combination of syntax, but everytime it generates either an error.
So far the only query that was successful was ---> WHERE ([WHDeliveryDate] IS NULL)
But I need a condition that meets 2nd criteria.
Thank you in advance for your help.