As a common Human Resource activity, I am trying to calculate Tenure. In Excel, I would use: =DATEDIF(A2, TODAY(), “Y”) where A2 would be Hire Date. Is there a way to do this in Expressions?
You can do this with a time and date difference node:
Use any node that allows you to create a date column using today() function - e.g. Column Expressions.
Then use this node to calculate the difference with monthly granularity.
I think you will have to add 1 to the result in a math node after the date and time difference node.
This worked well. Thanks for the quick response.
1 Like
If your challenge is solved please consider flagging my response as solution - this way it shows up at the top if someone else comes across this topic when trying to solve the same / a similar challenge 
3 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.