Community,
Happy Tuesday.
I want to subtract two dates based on the results of a third field.
If the status is closed, then subtract Start Date from End Date.
All other statuses, subtract Start Date from Today().
Please see sample data.
Thanks!
Solved! Go to Solution.
IF [status] = "closed"
THEN datetimediff([End Date], [Start Date], "days")
ELSE datetimediff(DateTimeNow(), [Start Date], "days")
ENDIF
if [status] = "Closed"
then datetimediff([end],[start],'days')
else datetimediff(DateTimeToday(),[start],'days')
endif