Grouping by a date range

[oneilltnc]

I was wondering if anyone knew how to create a formula so that I can group on four different date ranges. Here is my problem...I need a group of four date ranges 15-30 days, 31-60 days, 61-90 days and Over 90 days. I need to show all calls that have not been responded to within those date ranges. So I can't just group on the date itself because there are many call reports with one day and I have to show all of the calls still outstanding. The report is an Aging report that takes the date the call was placed and then takes the current date to get the date difference. The report needs to be grouped by aging period and I also need a subtotal on the number of calls still not responded to within each one of the aging periods. If anyone has any ideas on how to do this I would appreciate it. Thanks.

 

[synapsevampire]

Create a formula to group on:

If currentdate-{table.datefield} in [15 to 30] then
"15-30"
else If currentdate-{table.datefield} in [31 to 60] then
"31-60"
else If currentdate-{table.datefield} in [61 to 90] then
"61-90"
else If currentdate-{table.datefield} > 90 then
"Over 90"

-k

 

[oneilltnc]

That worked perfectly. Thank You!