AnsweredAssumed Answered

Birthdays

Question asked by ChronoVII on Nov 18, 2008
Latest reply on Nov 21, 2008 by Stephen Huston

Title

Birthdays

Post

I'm not sure if i explained it clearly below but here's my dilemma:

 

I have a database where we store all the information on our staff. In this database, I have a calcuation that states : If ( Month ( DOB ) = Month (Get ( CurrentDate )) and
Day ( DOB ) = Day (Get ( CurrentDate ));1)

 

In the other database, I have it a relationship for the calculation field in my personnel database (i.e, this relationship is only true if the month and day matches a birthday). This way, on birth dates, a little message pops up that says "Happy Birthday! XYZ" and a little picture.

 

This is not working :(. This link does not dynamically update daily, so i have to manually check if anyone has a birthday on any particular day and then retype their birthday into the DOB field to force the calculation to update.

 

Is there a way to automate this? If so, how? 

Outcomes