Date Expression without the Year

[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

 

[Steven Burn]

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

 

[Paul Overway]

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.