dates

[Guest]

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

 

[Adrian Jansen]

You have to delimit the date string with # signs:

WHERE cprduedate = #mm/dd/yyyy#

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Grant]

Don't know if this will work in asp though

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

Regards
Grant