dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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.
 
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
Click to expand...

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())
 
Back
Top