Date Query

[susanlang]

I am trying to do a query to flag up an item which is due two weeks later?

I hope this make sense.

Thanks

 

[mp9]

Hi Susan,

Let's say your table is called tblOrder, and the "date due" field within it is called DateDue and is of a Date/Time datatype. The following query should then return all records due within the next two weeks:

SELECT * FROM tblOrder WHERE DateDue BETWEEN Now() AND (Now()+14);

Equally, the following should return all records due in more than two weeks:

SELECT * FROM tblOrder WHERE DateDue > (Now()+14);

HTH.

http://www22.brinkster.com/accessory/