Calculation field working out a person's age doesn't recalculate
I have a stand alone application created with FileMaker Pro 9 Advanced.
On the client screen there is a Date of Birth field and an Age field. The Age field is a calculation: For example a child born 1/1/2005 has the Age he was when his record was first created, not the Age he actually is now.
Let([n = Get(CurrentDate); b = date of birth];
Year(n) - Year(b) - ((Month(n) + Day(n) / 100) < (Month(b) + Day(b) / 100)) )
The Date of Birth field is held as a Date field.
The Age gets calculated correctly but when I revisit the client record months or years later, the Age has not been recalculated.
Any thoughts on how I can fix this ? It works perfectly in the equivalent system before it is converted to a stand alone.
For example a child born 1/1/2005 has the Age he was when his record was first created, not the Age he actually is now.