Forum Discussion

MikeMurray's avatar
MikeMurray
Qrew Cadet
10 years ago

Is there a way to calculate age in years, months & days?

I currently use a formula, which works fine, to calculate age in years. Going forward I need to calculate years, months & days. This is the formula I'm using now:  var Number BirthYear = Year ([Date...
Formulas and functions
Tables and fields
MikeMurray's avatar
MikeMurray
Qrew Cadet
10 years ago
Hi Xavier, sorry for the delay in responding I was off for a few days. I thought to try for the same accuracy as the duration calculators I've used online. I have one age (DOB 1/27/2006) coming out as 9 yrs. 12 months & 0 days which looks odd on a report.