List Box Issue

[balrammahato204]

Hi All,

If some one can answer this question please help me out,

Dec-13

Jan-14

Feb-14

Mar-14

Apr-14

May-14

Jun-14

Jul-14

Aug-14

Sep-14

Oct-14

Nov-14

Dec-14

Jan-15

Feb-15

Mar-15

Apr-15

May-15

I have data like this and i want to show my data in the list box only from JAN-15 to MAY-15. How can i do this.

[stigchel]

Use an expression (bottom of the field list) and there use something like

=if(Year=2015,Month)

[Gysbert_Wassenaar]

Use an expression for the listbox: if(match(MyListboxField, 'Jan-15','Feb-15','Mar-15','Apr-15','May-15'),MyListboxField).

Another (better) solution is to create a Year field in the script, add a listbox for that field and select 2015 in it.

[Kushal_Chawda]

Create Year field using Year(MonthName) and use this Year filed in list box to select 2015