3 Replies Latest reply: Feb 7, 2017 5:27 PM by Sunny Talwar RSS

    Can you explain this expression to me

    Mark Ritter

      I sort of know what it is doing.  But not 100% sure.


        if(Current_Active, MakeDate(2016,7),Date#(termination_date,'YYYY-MM-DD')),

      Date#(Hire_Date_Most_Recent,'YYYY-MM-DD')) as Tenure


      Ultimately it is calculating the length of time an employee worked for the company if they terminated.  What is the MakeDate(2016,7) actually doing in this expression?