1 of 1 people found this helpful
I would use the DiffDays function.
Ex. $(DiffDays(startDateTime, endDateTime)
In that case, you would want to look into the HOPCalcDuration function. This will take into account of what you set your HOP to be. See setting up Hours of Operation in the admin documentation.
A few things.
1. The HOPCalcDuration function will not work for a live calculation since the moment you plug in the first date, the function will try to calculate without giving you a chance to plug in the second date. An "AfterSave" in the condition will fix this for you.
2. Keep in mind that this calculation is based on seconds, so if you want a day value, divide it by the number of seconds in a day which is 86400.
3. Make sure the HOP you use is based on Whole day if you're accounting for the whole day and not your business hours.