less than 30days till date 1

[ralphus]

What would i put into criteria so that the query would show all records that have less than 30days till the expiry date is reached.
This fied is in date and time format
Cheers

 

[mp9]

Use the Now() function in the SQL of your query.

Example, table is tblTest with fields MyID and MyDate:

SELECT MyID, MyDate
FROM tblTest
WHERE MyDate Between Now() And (Now()+30);

Hope this helps.

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