Re: Age Calculation

Here is a formula to calculate age in decimal years. It will be blank if negative.

AGE and decimal months

// replace the [DOB] field with your date of birth field

var date DOB = [DOB];

var number Years =

Year(Today())-Year($DOB)
-
If(
Month(Today()) 0, $MonthsDifference, 12 + $MonthsDifference);

Var Number Age = Round($Years + $Months/12,0.1)

If($Age >= 0, $Age)