aging based on invoice date
How do I create a formula that calculates how old an item is based on date (ex. aging based on invoice date or aging based on due date) Current 1week old 2 weeks (etc) Current 30 days 60 day...
Forum Discussion
Typically its a formula like this.
var number AGE = ToDays([Today()-[Invoice Date]);
IF(
[AGE] < 30, "Current",
[AGE] < 60, "30+",
[AGE] < 90, "60+", "90+")
var number AGE = ToDays([Today()-[Invoice Date]);
IF(
[AGE] < 30, "Current",
[AGE] < 60, "30+",
[AGE] < 90, "60+", "90+")