Employee Tenure Based On Hire Date

user02480
user02480 Member
in Magic ETL

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.  

Best Answer

  • AS
    AS Coach
    Answer ✓

    This is what we use for tenure in years:

     

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

    Aaron
    MajorDomo @ Merit Medical

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

Answers

  • Valiant
    Valiant Coach

    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.

  • AS
    AS Coach
    Answer ✓

    This is what we use for tenure in years:

     

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

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user02480
    user02480 Member

    Thank you!  That worked!

Categories