Calculating age from birhtdate

[andygaunt]

Hi,

I am not sure what you mean by

It works, but sometimes when a birthday comes and goes it doesn't update the new age.

in the calculation field storage options check the Do not store calculation results.

This will force it to recalculate the age every time you look at the record.

See if this works for you.

[Vaughan]

First thing, replace the TODAY function with Status(CurrentDate). Today has problems.

Second thing, try changing the calculations field's storage to "unstored". This forces FMP to re-calculate the value each time it is needed. This can slow things down, but the value will always be correct.

[tomr40]

In a db of Driver Ed students I use this formula to calculate age from birthdate [dd/mm/yyyy]:

Year[Today] - Year[birthdate] - If[Today< Date[Month[birthdate], Day[birthdate],Year[Today]],1,0]

It works, but sometimes when a birthday comes and goes it doesn't update the new age. Is there a command to force it to recalculate?