List Box data - restrictions

[anthony_kinsell]

Hi,

If I have a list box that displays YearMonth in the format MMM-YYYY from say Jan 2009 to Dec 2026 how do I restrict the valuse shown to say Jan'11 to Dec'14?

[luis_pimentel]

At the ListBox Properties, "General Tab", you can set a "Expression" inestead of a Fieldname. Then, in that expression, add any conditions you want to. This <Expression> option should be at the bottom of your fieldnames list.

The snapshot is in Spanish, sorry:

[manojkulkarni]

use expression instead of field : Expression will be if(YearMonth>='Jan-2011' AND YearMonth <='Dec-2014',YearMonth)

[anthony_kinsell]

Cheers Guys,

I was trying to put the expression is the 'expressions' tab & it wasn't working.

[manojkulkarni]

=if(MY>=Date(MakeDate(2013,01,01),'MMM-YY') AND MY <=Date(MakeDate(2013,12,31),'MMM-YY'),MY)

MY is your month Year in the format Jan-13. Change the format according to your requirement.