Don't know if this will work in asp though

WHERE (DateDiff("d",Now(),[cprduedate]))30

Regards
Grant


wrote in message
hlink.net...
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