Restricting Rolling Months Value

[alkesh_sharma]

Hello, I need help reg. restricting values in rolling month.

I have data for five years, but i need to display the values of Rolling months for last 2yrs (24 month) in a list box.

Thanx in advance.

[#2]

If you are displaying only 24 months data throughout your application then filter remaining 3 yrs data from data model itself. It will help to show desired results, also it will reduce size of the application.

[alexandros17]

write this expression in your list box instead of input the field

=if(Year > year(today())-2, Year, null())

[amit_saini]

Hi Alkesh,

Try This:

if(makedate(Year,POPER)>=monthstart(addmonths(Today(), -23)) and makedate(Year,POPER)<=MonthEnd(Today()), 1, 0) as %isRollingMonth

Thanks,

AS

[alexandros17]

Excuse me I was wrong, try this

=If(myDate > AddMonths(Today(),-84), MonthYear, null())

[alkesh_sharma]

This solved the problem....Thanx