Calculating Days aged on Invoices

[Edward Newman]

This is bugging me! I am trying to set up a calculation field for my invoices module. I have a field 'invoice date' and 'today' field. I want to calculate the number of days between the two, but can't figure it out. Any one out there help?

[LaRetta]

Hi Edward,

You only need your InvoiceDate field and a calculation (number). To produce just the total numbers of days past due, it would be:

Status(CurrentDate) - InvoiceDate

But you might also want to account for the Invoice still having an outstanding amount; whether a payment field is empty? Or whether InvoiceAmount - PaymentAmount > 0?

You may also wish to group them for Aging purposes to display those overdue 30-59 days, 60-89 days, 90-119 days and 120+ days. This can all be accomplished within this one calculation if you wish.

If you want to take the thinking further than number of days old, let us know and we can provide the calculations.

LaRetta