Employee Tenure Based On Hire Date

user02480

What is the Beast Mode Formula for calculating employee tenure using their Hire Date?  I am trying to create a card that shows average tenure per office.  

AS

This is what we use for tenure in years:

 

DATEDIFF(CURDATE(),`hire_date`)/365

Valiant

You could do something like this:

AVG(DATEDIFF(CURRENT_DATE(), `Hire_Date`))

DateDiff using Current_Date and Hire Date will give you the # of days each employee has been employeed. Averaging that by office should give you what you're looking for.

 

Hope that helps,

Valiant_Ronin

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

user02480

Thank you!  That worked!