Date Functions

Diagram: invoices minus payments give the open amount, days overdue are calculated from the due date, and each amount falls into Current, 1-30, 31-60, 61-90 or 90+ columns per customer

Aging Report in SQL Server: Group Unpaid Invoices into 0-30, 31-60, 61-90 and 90+ Days

Simplify Database / October 26, 2026

Build an accounts receivable aging report in SQL Server step by step: open amount per invoice, days overdue, aging buckets per customer, totals, and common mistakes.

Aging Report in SQL Server: Group Unpaid Invoices into 0-30, 31-60, 61-90 and 90+ Days

SQL Date Functions Explained Simply (SQL Server and MySQL)