AnsweredAssumed Answered

Age calculation not updating

Question asked by NickJ72 on Nov 15, 2009
Latest reply on Nov 15, 2009 by NickJ72

Title

Age calculation not updating

Post

I am using FileMakerPro 9.0v3 on Mac OSX 10.6.1.

 

I have a student database, in which I have created a calculation field to show the age of each student, calculated from their date of birth: 

 

Year (Get ( CurrentDate )) - Year (Date of Birth) - If (Get ( CurrentDate ) < Date (Month (Date of Birth); Day (Date of Birth); Year (Get ( CurrentDate ))); 1; 0)

 

However, I have noticed that when a student has their birthday the age field is not automatically being updated. I have to re-enter the date of birth manually. Is there a work-around for this?

Outcomes