Date Range Pulling Only Month

S

Sue

I am trying to create a query using a date range parameter [Birthdate] that
will pull just by month not by year and is ascending order. The criteria I
used was Between [Type Begin Date] and [Type End Date]. Any ideas???

Thanks, Sue
 
J

John W. Vinson

I am trying to create a query using a date range parameter [Birthdate] that
will pull just by month not by year and is ascending order. The criteria I
used was Between [Type Begin Date] and [Type End Date]. Any ideas???

Thanks, Sue
Click to expand...

Just what do you mean by "pull by just month"?

If [Birthdate] in fact contains the date of the person's birth, and you want
to find this year's birthday anniversaries, put a calculated field in your
query:

HappyHappy: DateSerial(Year(Date()), Month([Birthdate]), Day([Birthdate]))

This will calculate the current calendar year's birthday anniversary date (use
with caution in December in other words). To find all upcoming birthdays, you
could apply your criteria to this calculated field, or use a criterion such as
= Date() AND < DateAdd("m", 1, Date())
Click to expand...

to get all the birthdays for the next month from today (i.e. 11/13 - 12/13 if
run today).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Querying Date Field, Disregarding Year 2
Query for previous week, Sun thru Sat, from date field 1
Changing Year in Date Range 1
Parameter query with date field 8
Excel Message box with days of month & date. 1
query filter for end of current month 3
date evaluation on Day and Month Only 1
query birthdates occuring in year range 2

Top