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

    Age calculation not updating

    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?