Date Range Pulling Only Month

  • Thread starter Thread starter Sue
  • Start date Start date
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
 
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).
 
Back
Top