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
I think somehow I lost part of the formula when I pasted it in.
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)