birthday reminder


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
 
Ad

Advertisements

J

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.
 
T

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
 
Ad

Advertisements

Joined
Dec 7, 2013
Messages
1
Reaction score
0
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])))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

birthday reminder 3
Birthday form 3
list of birthdays 1
Birthday and Image 3
Reminder 3
Sorting birthdays in groups 8
Email Reminders 2
Reminder Problem 3

Top