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)
benz-fsproduce , assume Termination Date is blank for active employess
Tenure days = DATEDIFF(page[Last Hire Date], coalesce(page[Termination Date], Today()) , Day)