How are Age Days calculated in the Report Designer?
FAQs > How are Age Days calculated in the Report Designer?
Age Days (with the table path Invoice.OperationsInvoice.AgeDays) are calculated using the formula below:
Current Date − Due Date = Age Days
If your Report Designer report shows a large number of negative Age Days, check the Due Date to make sure the month and year values are correct. For example, entering 2109 instead of 2019 will skew the Age Days calculation.