Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I sort of know what it is doing. But not 100% sure.
Age(
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?
Yes, if the employee is active then July 1st - Hire Date, else Termination date - Hire Date
That is hardcoded date of July 1st 2016
Make date take the following paramters:
MakeDate(Year, Month, Day)
I figured that. But how is that date being used in this calculation?
Is it saying if Current_Active then use July 1st 2016 else use the termination date?
Yes, if the employee is active then July 1st - Hire Date, else Termination date - Hire Date