Selection auto in List box

[christophebrault]

Hi,

On my application, i want to select multiple month.

For example, today, when i open the sheet, i want to select month from january to september, but not october.

How can i trigger this ?

Thanks

[Anonymous]

You can create Action OnOpen:

Select in Field:  Month
Search string:  ='>=' & date(yearstart(reloadtime()),'MMM-YY') & '<' & date(monthstart(reloadtime()),'MMM-YY')

Notice that date format matters.  I'm using 'MMM-YY' here, it maybe different for you.