Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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:
use expression instead of field : Expression will be if(YearMonth>='Jan-2011' AND YearMonth <='Dec-2014',YearMonth)
Cheers Guys,
I was trying to put the expression is the 'expressions' tab & it wasn't working.
=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.