### Title

Age: Calculating from Timestamp - Birth

### Post

I'm sure there have been many previous requests, but coming from Excel where such a calc is easy, I'm have trouble understanding or doing the complexity of an FM calc.

I'd like to get: Age (accurate and as a decimal) from a Record Timestamp - Birth date.

But I'd like to understand the underlying logic too!

Thanks,

Stephen

Originally from LaRetta:

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.

--------------------------------------

Or

--------------------------------------

Case ( DOB and Get ( CurrentDate ) ; Year ( Get ( CurrentDate ) ) - Year ( DOB ) - ( DayOfYear (Get ( CurrentDate ) ) < DayOfYear ( DOB ) ) )

---------------------------