selection criteria in a trigger

[#1]

Hi,

I use a trigger - 'Select in Field' to select a month-year condition.

Date(monthStart(date(addmonths(today(),-1))), 'MMM-YY')

Whenever, I select the sheet, the above trigger condition will select Feb-12 in the MonthYear list box automatically.

I want to know if its possible to select the latest available data in the MonthYear list box.

So, whatever be the monthyear be it Feb-12 or Mar-12 or anything else, the latest monthyear is always selected.

MonthYear listbox contains data as follows:

Date(monthStart(today()), 'MMM-YY') AS MonthYear for some particular condition.

Thanks.

[CELAMBARASAN]

Hi,

     Try with this

     Search string as =Max(ALL MonthYear)

Celambarsan

[jagan]

Hi,

Try setting the Search string as

=Max(TOTAL MonthYear)

Regards,

Jagan.