Convert Duration in Days to Years

EricRovner
Qrew Member
3 years ago
Thanks so much Mark - just what the doctor ordered - super appreciate the quick assist!

------------------------------
Eric Rovner
------------------------------
EricRovner
Qrew Member
3 years ago
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
------------------------------
- JeffPeterson1
  Qrew Captain
  3 years ago
  Try it like this:
  
  ToNumber(Todays(Today() - [Hire Date]))/ 365
  
  ------------------------------
  Jeff Peterson
  ------------------------------
  - EricRovner
    Qrew Member
    3 years ago
    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
    ------------------------------

Forum Discussion

Convert Duration in Days to Years