This content has been marked as final. Show 3 replies
I sort of know what it is doing. But not 100% sure.
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?