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?