filter on selection list box

[#1]

I have an QV-application with several sheets.

The history in the data is from the last 5 years. Now I want to privide to use only the data of the last 2 year on 2 sheets in the year selection list box.

Now users can choose in 2008, 2009, 2010, 2011, 2012, 2013.

I assume it's simple but how to privide that they can only choose in 2012, 2013

[tresesco · Accepted solution]

take a list box, in the general tab, select <Expression> instead of the year field, write this:

=If(YourYearField=2012 or YourYearField=2013,YourYearField)

in the expression.

[sathishkumar_go]

HI, use this in list box IF(Year > 2011,Year) -Sathish