dates

message from jjrmy1 on 11 May 2004

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 replied to jjrmy1 on 11 May 2004

Answered elsewhere.
Please do not multi-post.
If you feel you must post the same question to more than one newsgroup
(and it's seldom necessary), cross-post by adding each additional
newsgroup in the To Newsgroups: box, separated by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

John Vinson replied to jjrmy1 on 11 May 2004

The format of the date is irrelevant: that just controls how it's
displayed, not what's stored.

For "the next thirty days" you can use a criterion of

BETWEEN Date() AND DateAdd("d", 30, Date())

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Archived message: dates (Microsoft Access Database)