This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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!
