Help

Help calculating age (since date)

Topic Labels: Formulas
Solved
Jump to Solution
1293 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ianonline
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, I’m trying to get a formula working to determine age in years with one decimal place. The date is in a column called “Created”, the formula I’ve got is:

DATETIME_DIFF(TODAY(), Created,'years') & ' years'

Can anyone help add the decimal place so the result for example is “1.2 years”?

Thank you.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

DATETIME_DIFF will only return whole years. It will not return a decimal. If you want a decimal, you should find the age in months or days, and then convert the result to years manually.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

DATETIME_DIFF will only return whole years. It will not return a decimal. If you want a decimal, you should find the age in months or days, and then convert the result to years manually.

Thanks for the suggestion, if possible I’ll avoid overcomplicating it, so I decided to just make it count the number of months.