Conditional Listbox View

[Anonymous]

I have data as far back as 1998. I need to create a Fiscal Year listbox that only lists from 2006 forward.

[Anonymous]

PS: What how do I set the view to only show from 2006 forward?

[#3 · Accepted solution]

I think you could do something like this:

=if(Year(Date)>='2006',Date,)

[#4]

In ListBox - Columns, the very first option is to use an expression.

Use

=if(Year(Date) >= '2006', Year(Date))

[Anonymous]

I don't see ListBox - Columns. List box only gives me the ability to choose 1 field.

[#6]

On the 'General' tab of the Listbox Properties, it's under Field <Expression>

Here you can put the expression.

[Anonymous]

Thank you Xena. I was able to enter the expression substituting Date for the field name FiscYear. I got no return values.

[Anonymous]

=if(FiscYear >= '2006', FiscYear)

I modified the expression to the above and it works. Thank you guys for all your assistance!