This link will help you with your calculations:
Use a CASE function in your CurrentAge calculation field with the needed statements from the link above.
all the best.
Let ( [ today = Get ( CurrentDate) ; m = 12 * ( Year ( today ) - Year ( DOB ) ) + Month ( today ) - Month ( DOB ) - ( Day ( today ) < Day ( DOB ) ) ] ; Case ( m ≥ 24 ; Div ( m ; 12 ) & " years old" ; m ; m & " months old" ; today - DOB & " days old" ) )
Note that "month" is a rather flexible term. This calculation assumes that a person becomes a month older on the same day-in-month as his birthday or when the month ends - whichever happens first. The side effect of this is that some people become 1 month old after being 30 days old, others after 29 or 28 or even 27.
I'd forgotten how much I love this stuff. It's like figuring out a puzzle or a mystery.
Looks like people already gave you your answer.
Wow... thanks "Comment"!! That works perfectly. :robotvery-happy: