Skip to main content
Question

Past Due count formula

  • January 27, 2019
  • 0 replies
  • 49 views
I want to have a formula numeric field called "Past Due" do the following...

If [Invoice Due Date] is = or > 30 days past and [Invoice Paid Date] is blank then keep the count of how many days past due in the [Past Due] field.  It would be nice if it is in red too.

Thanks and sorry for such a basic formula but I just can't seem to nail down date formulas.
      This topic has been closed for replies.

      Try this as a formula rich text field

      var Number PastDueDays = Max(0, ToDays(Today() - [Invoice Due Date]));

      IF(IsNull([Invoice Paid Date])
      and $PastDueDays >= 30, "" & ToText($PastDueDays))

      This is not tested so if there is a syntax error please copy and paste your code and the error message.
      Terms & ConditionsAccessibility statement