I’m trying to calculate the number of days someone has worked in a job. I’m familiar with the DATETIME_DIFF() function, which works great when you have a Start Date and an End Date, but what if you don’t have an end date?
In other words, imagine that someone is currently in their position, therefore the field registering their end date is empty.
The theoretical solution I came up with is creating another field with the formula TODAY(), and then, if the field for end date is empty, use the field for today to calculate the difference between today and the start date, and calculate the time that the person has worked.
I’m having trouble with the syntax! Any thoughts be greatly appreciated.