hi everyone!
does anyone know how to filter a recordset for a specific date.
for example. i keep some dates in an access database of cpr training. i am
making a repeating region listing the people whose cpr license will expire
in 30 days. well how do you construct that kind of sql sentence
SELECT*
FROM table
WHERE cprduedate = <<<<<<<what>>>>>>>
i'm completely lost! i keep dates in form mm/dd/yyyy and am using asp.
thanks a bunch in advance

jjrmy1 (AT) earthlink (DOT) net wrote:

SELECT *
FROM table
WHERE ((Table.cprduedate)<=DateAdd("d",30,Date()));

This will give you all the people who expire in less than 30 days from
today.
SELECT *
FROM table
WHERE ((Table.cprduedate)=DateAdd("d",30,Date()));

This will give the people who expire exactly in 30 days from today.

Be well