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
MarkShnier__You
Qrew Legend
Qrew LegendTry this
Change the field type to formula numeric
Todays(Today() - [Hire Date])/ 365
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Change the field type to formula numeric
Todays(Today() - [Hire Date])/ 365
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
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
------------------------------- 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
------------------------------
