Forum Discussion
Solved
Tenure Days
Hi, I am trying to calculate tenure days, in a new column, of employees based on my columns "last hire date" and "termination date". My current formula is: Tenure days = DATEDIFF(page[Last Hire Date]...
benz-fsproduce , assume Termination Date is blank for active employess
Tenure days = DATEDIFF(page[Last Hire Date], coalesce(page[Termination Date], Today()) , Day)
You could create a variable (something like var1 = COALESCE ((terminationD, TODAY()) )
and then use the variable in the datediff.
I think COALESCE works in this context, if not you can explicitly check for a null or blank termination date .