EricRovner
3 years agoQrew Member
Convert Duration in Days to Years
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
------------------------------
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
------------------------------