Limiting Data in a List Box

[#1]

Is there a way to limit the data in a list box. The table my list box pulls data from goes back to 2009. I would like to hahve the list box only pull data from 2011.

Thanx

[#2]

Hi,

Use a calculated expression instead of the field itself. For example, if the field in the list box is called "A", create an expression like:

({$<[Year]={2011}>} A)

[pat_agen]

hi,

you can enter an expression in your list box. On the general tab of the properties dialogue open the drop down list of fields. Scroll to the top and select <Expression>. the expression dialogue will open. Enter something like this:

=if(Year=2011,fieldToBeDisplayedHere)

hope this helps

[#4]

Following your lead, this is the formula I used.

=if(CloseDate_MY >='01-2011',CloseDate_MY)

Unfortunately it's doing noting...as if I didnt type any thing in. Do you see an issue with the syntax?

[#5]

I tried the syntax as such:

=({$<{CloseDate_MY} >={01-2011}>} CloseDate_MY)

Unfortunately Im getting error in expression. Any idea?

[pat_agen]

hi,

how is the field ClosedDat-MY defined? Is this a date field?

You probably need to do some processing on this field to have it comparable to a string such as '01-2011'. perhaps something like:

if(Date(ClosedDat_MY,'MM-YYYY')>='01-2011',CloseDate_MY)

[#7]

Yes, the CloseDate_MY is a date field formatted for MM-YYYY

[pat_agen]

did you try the code as posted?

if(Date(ClosedDat_MY,'MM-YYYY')>='01-2011',CloseDate_MY)

[#9]

Yes, but unfortunately, there seems to be no effect on the list box...all of the month year data shows back to 2009

Thanx

[yasus]

Hi fuji,

I would just add a dedicated field for your listbox within the load script.

Example:

LOAD *,
if(Yearmonth<201102,Yearmonth) as ModListBox
From //