Ashley_Conway - profile

Ashley_Conway · Aug 26, 2020

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...

Ashley_Conway · Aug 26, 2020

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!

User Statistics

User Activity

If Invoice is past due, display number of days past due

Re: If Invoice is past due, display number of days past due