AnsweredAssumed Answered

calculating age?

Question asked by bobinaustin on Mar 9, 2016
Latest reply on Mar 9, 2016 by Vaughan

I have a series of date of birth fields: dob1, dob2 etc... and i would like to display a field next to each that displays the age in years.  The dob field will be entered and displayed like this: 1/1/2016

 

i have seen this calculation but i have no idea what to do with.  i assume age is a field name and the Birthdate is the dob field i have already?

age = Year ( Get ( CurrentDate ) ) - Year ( Birthdate ) - ( Get ( CurrentDate ) < Date ( Month ( Birthdate ) ; Day ( Birthdate ) ; Year ( Get ( CurrentDate ) ) ) )

Outcomes