I have a report that calculates the number of days a ticket has been opened. I need to group by over 60 days, over 45 days, over 21 etc. How can I set that up in Info Assist?

This message has been edited. Last edited by: MelissaReed,

You have to use a DEFINE under DATA tab to create buckets for each of these values. If the OPEN_DATE is an HYYMD format field, define today's date, difference between today and OPEN_DATE and then use an IF THEN ELSE to bucket the values you get in it. You should then be able to sort BY or ACROSS BUCKET.

Here's something you could use to start your code.

TDAY/HYYMD WITH OPEN_DATE = DT( &YYMD );
DIFF_DAYS/I5 = HDIFF(TDAY, OPEN_DATE, 'DAY', 'I5');
BUCKET/A20= IF DIFF_DAYS GT 21 THEN ......ELSE....

Thank you, that worked.