3 Replies Latest reply on Nov 15, 2009 3:45 PM by NickJ72

    Age calculation not updating



      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?