multi box show values

[francis_gr]

Hi!

Ì have a multi box that it allows me do selections using 3 fields. One field is año_inicio. Their values are a range between 2005 to 2010.

I would like to show only present and previous year ( 2009 y 2010)

how I can obtain it?

Thanks

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

Go to your multibox and instead of selecting a field from the left list, click on the "Expression >" button, and add something like

=If(año_inicio > 2008, año_inicio)

and label it as you want.

Regards

[johnw]

I'd base it on the current date so that I didn't have to change my application each year, but same idea:

=if(año_inicio>year(today())-2,año_inicio)

[francis_gr]

Thanks Miguel!!

That works fine.

thanks

[francis_gr]

Thanks John!!

Starting off of the idea from Miguel, i have arrived the same expression that you.

Regards