Skip to main content
Question

Convert Duration in Days to Years

  • February 26, 2022
  • 0 replies
  • 198 views

I am trying to calculate length of employment for our employees. I've been "successful" in being able to generate two fields - one for # of years and once for # of months. But, what I really need is a single field that shows # of years with a decimal point.

​I've used the formula (Today() - [Hire Date])/365 - yielding an adequate result for my needs (# of years with a decimal point) but it is labeled as days not years. (2/25/2022 - 12/15/2017)/365 = 4.2 days

Any assistance would be greatly appreciated as this is driving me nuts and I couldn't find a clear resolution for this topic within the community posts.​

Thanks!​

------------------------------
Eric Rovner
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Try this

Change the field type to formula numeric

Todays(Today() - [Hire Date])/ 365

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------