Date Expression without the Year

  • Thread starter Thread starter Ryan Durnell
  • Start date Start date
R

Ryan Durnell

I am working on a report that polls the birthday of people 1 week ahead of
time. My problem is that the Date( ) Field polls the year 2003 and I need
all years

Between Date()+7 And Date()+14
 
Someone else posted a Q about this and got it resolved. Do a search on this
newsgroup (should turn something up).

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk
 
You need to manipulate the date of birth a little, i.e., create a column
with the following expression (DOB represents the persons birthday):

AnniversaryDate: DateSerial(Year(Date()),Month([DOB]),Day([DOB]))

Then enter your criteria from below in the column.

This returns the anniversary date (a date in the current year) based on the
person's birthday.

Note that persons born on February 29 will have an anniversary date of March
1, if the current year is not a leap year. So, you may want to include the
actual DOB as another column in your query.
 
Back
Top