Can we apply filter on bo report based on sys date?

[rrbo]

Hi All,
I have a cross tab report , In that i have a object MONTH at row level. Month contains values 1,2,3,4...to 12.

I wanna filter on MONTH based on Sysdate. If sys date month is MAY(5) then that should filter for 3,4 and 5. If Sys date month is October then that should filter for 8,9,10.

I am unable to get how to do this. If u find somethinmg about this please post it. If you get an idea at Universe level about this , give me syntax for that.

Thanks
rrbo

 

[Sridharan]

Hi,

To get the Current Month you can use Month(Now()) and then maybe have some other variables to hold the last two month values and filter the report accordingly.

Sri