birthday reminder

  • Thread starter Thread starter Tia
  • Start date Start date
T

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
 
What formula should I use to give me the month and the day for this
year
Click to expand...

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.
 
What formula should I use to give me the month and the day for this
year
Click to expand...

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.
Click to expand...

Thank you very much
 
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 :cheers:

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