Aging type report

[LOUM]

Hello,

I am trying to create an aging report that return the results I would like in Report Studio. I want to color code the data based on the last issued date. I want to identify what has not been issued in 30, then 60 and finally 90 or older.

How should I write this? If([Issue date] between (current_date,-31)  and (current_date,-60)) then ('30')

If([Issue date] between (current_date,-61)  and (current_date,-60)) then ('90')
Then ('60')

If([Issue date] > (current_date,-92)
Then ('90')

else ('0')

[cognostechie]

If [Issue Date] between _add_days(current_date,-30) and add_days(current_date,0) then ('30') else

If [Issue Date] between _add_days(current_date,-60) and add_days(current_date,-31) then ('60') else ....

go on..

[LOUM]

 ;D

Thank you, worked like a champ!

Lou