dates

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

[fredg]

On Tue, 11 May 2004 22:11:25 GMT, <jj****@earthlink.net> wrote:

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

WHERE [cprduedate] between Date() and Date() + 30

or if you would like a full calendar month (28 to 31 days):

WHERE [cprduedate] between Date() and DateAdd("m",1,Date())

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.