I’m getting stuck on this formula, please help! I have the following fields:
Status (single select)
Due Date (date)
I would like to have a new field “days past due” that shows the number of days past the due date IF the status is “past due”. Otherwis...
Jeremy_Oglesby:
IF(
{Status} = "Past Due",
DATETIME_DIFF(TODAY(), {Due Date}, 'days')
)
Thank you! That solution worked. Wouldn’t it be great if we could use math operators with dates!
