Try something like:
Let ( [
m = 12 * ( Year ( DateCollected ) - Year ( DOB ) ) + Month ( DateCollected ) - Month ( DOB ) - ( Day ( DateCollected ) < Day ( DOB ) )
Case ( m ≥ 12 ; Div ( m ; 12 ) & " Years, " ) & Mod ( m ; 12 ) & " Months"
---Note that this assumes a person becomes a month older on the same day-in-month as their DOB or when the month ends - whichever happens first.
OK that works great! But now that i see the result of the calc I think that if an individual is <1 a result in months would be OK...but if >1 just a result of years would do fine. Is there a way to adjust the calc to yield those results?
For example if DateofBirth is <1, result would be "X Months" or if age >1 then result would be "X years.
Thanks for the help. Your clearly more up to speed on this than I. I was rocking and rolling with FM until 7 came out. Now I've in the dark on alot of things that used to be easy for me. I guess it's age!!
Just change the result line to:
Case ( m ≥ 12 ; Div ( m ; 12 ) & " Years" ; m & " Months" )