birthday reminder

[Tia]

Dear,
I have a list of employees with a list of birthdays, I'm trying to set
a birthday report to know who's birthday is today .
What formula should I use to give me the month and the day for this
year

Thank you in advance

 

[Arvin Meyer [MVP]]

Here's a demo of what you need:

http://www.datastrat.com/Download/Birthday2K.zip

 

[John W. Vinson]

What formula should I use to give me the month and the day for this
year

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

will give you this year's birthday anniversary for a date of birth stored in
DOB.

You can use a query with this as a calculated field with a criterion

BETWEEN Date() AND Date() + 7

to get all the birthdays coming up in the next week.

 

[Tia]

What formula should I use to give me the month and the day for this
year

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

will give you this year's birthday anniversary for a date of birth storedin
DOB.

You can use a query with this as a calculated field with a criterion

BETWEEN Date() AND Date() + 7

to get all the birthdays coming up in the next week.

Thank you very much

 

[sticks221]

Thanks for the formula its exactly what I needed. It does howver fail to warn of a date in January when the current month is December. The following slight mod of adding an extra year if the month is prior to the current resolves the issue though

Date: IIf(Month([DOB])<Month(Date()),DateSerial(Year(Date())+1,Month([DOB]),Day([DOB])),DateSerial(Year(Date()),Month([DOB]),Day([DOB])))