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.
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.
write this expression in your list box instead of input the field
=if(Year > year(today())-2, Year, null())
if(makedate(Year,POPER)>=monthstart(addmonths(Today(), -23)) and makedate(Year,POPER)<=MonthEnd(Today()), 1, 0) as %isRollingMonth
Excuse me I was wrong, try this
=If(myDate > AddMonths(Today(),-84), MonthYear, null())
This solved the problem....Thanx
Retrieving data ...