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')
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..
;D
Thank you, worked like a champ!
Lou