AnsweredAssumed Answered

Chronological Age as of Certain Date

Question asked by cjsweatt on Jan 4, 2015
Latest reply on May 25, 2015 by rebfree

Hi Everyone!

 

I am in need of a chronological age field which counts as of December 1 of the current year.  I am using the following code to get the age:

FullAge (calculation, text result) =

GetAsText ( Year ( Get ( CurrentDate ) )  - Year ( Date of Birth ) - If ( Get ( CurrentDate ) <  Date ( Month ( Date of Birth ) ; Day ( Date of Birth ) ; Year ( Get ( CurrentDate ) ) ) ; 1 ; 0 ) ) & " Years, " & GetAsText ( Mod ( Month ( Get ( CurrentDate ) ) - Month ( Date of Birth ) + 12 - If ( Day ( Get ( CurrentDate ) ) < Day ( Date of Birth ) ; 1 ; 0 ) ; 12 ) ) & " Months, " & GetAsText ( Day ( Get ( CurrentDate ) ) - Day ( Date of Birth )  + If ( Day ( Get ( CurrentDate ) )  ≥ Day ( Date of Birth ); 0 ; If ( Day ( Get ( CurrentDate ) - Day ( Get ( CurrentDate ) ) ) < Day ( Date of Birth ) ; Day ( Date of Birth ) ; Day ( Get ( CurrentDate ) - Day ( Get ( CurrentDate ) ) ) ) ) ) & " Days "

What else do I need to add in order to have it count as of December 1 of the current year?

 

Any help is always appreciated!

 

Thank you!

Outcomes