AnsweredAssumed Answered

Age calculation not updating

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


Age calculation not updating


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?