Return to FileMaker.com
Age as of jan 1st 2011
I have a D.O.B field.
I need to know how i would calculate or a formula to find out.
they was born june 17th 2001
how old would they be as of jan 1st 2011
hope i somewhat explained this so anyone can understand.
I use this calculation:
Let ( [ Today = Get (CurrentDate) ; bDay = Date ( Month ( Birthdate ) ; Day ( Birthdate ) ; Year ( Today ) ) ] ; Year ( Today ) - Year ( Birthdate ) - ( Today < bDay ) )
This must be an unstored calculation or it will not update correctly as time passes.
Retrieving data ...