I am trying to calculate the cost of aged receivables in different time ranges. I want the total costs of receivables in the last 30 days, 31-60 days, 61-90 days and 91 and over depending on the date specified which will be most of the time today's date. I don't know how to create a SQL statement that would do this as a new year creates problems in determing the number of days ago it happened. I hope that makes sense. I'm having troubles getting my head around it and explaining it.

TIA,
Tyler