Past Due count formula
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 ...
Forum Discussion
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.
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.
- Works great thanks as always! What would I add to the formula to make the number red?
- Oh sorry. When I post from an iPad it sometimes eats part of the code.
I will update that the next time I�m at a computer. Those empty quotes had the syntax for the red color inside them. IF(IsNull([Invoice Paid Date])
and $PastDueDays >= 30, "<font color=red>" & ToText($PastDueDays))
