Age Calculation
I have a Date of Report field, a Date of Birth field and next to it we compute Age; how can I fill the Age field automatically based on DOB and the original date of the report?
Forum Discussion
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)
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)