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...
Forum Discussion
I apologize for having to come back to the well but I now have a related challenge. I'm able to calculate an employee's tenure in years with the numeric formula "Todays(Today() - [Hire Date])/ 365" but now I need to calculate the # of years with a decimal point for the amount of time between an employee's hire date and the static date they were reviewed.
I've tried using the numeric formula ([Review Date] - [Hire Date])/365 but I receive an error message stating; "The expression ([Employee - Hire Date]) on the left hand side of the operator "/" is of type date while the expression 365 on the right hand side is of type number. The operator "/" cannot be used with these types of expressions."
I'd sure appreciate any guidance toward a formula solution!
Thanks in advance, -Eric
------------------------------
Eric Rovner
------------------------------
I've tried using the numeric formula ([Review Date] - [Hire Date])/365 but I receive an error message stating; "The expression ([Employee - Hire Date]) on the left hand side of the operator "/" is of type date while the expression 365 on the right hand side is of type number. The operator "/" cannot be used with these types of expressions."
I'd sure appreciate any guidance toward a formula solution!
Thanks in advance, -Eric
------------------------------
Eric Rovner
------------------------------
Try it like this:
ToNumber(Todays(Today() - [Hire Date]))/ 365
------------------------------
Jeff Peterson
------------------------------
ToNumber(Todays(Today() - [Hire Date]))/ 365
------------------------------
Jeff Peterson
------------------------------
- Thanks Jeff. To clarify, I'm trying to determine the # of years with a decimal point between a static date [Review Date] and a static date [Hire Date].
Not sure how to apply your solution to my specific need.
------------------------------
Eric Rovner
------------------------------- Ah sorry I misread your question. I think this would solve it.
Todays([Review Date] - [Hire Date])/ 365
------------------------------
Jeff Peterson
------------------------------- Perfect - thanks so much for the assist Jeff! :)
------------------------------
Eric Rovner
------------------------------