selection criteria in a trigger

Fri, 02 Mar 2012 13:04:02 GMT

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 — Fri, 02 Mar 2012 13:06:26 GMT

Hi,

Try with this

Search string as =Max(ALL MonthYear)

Celambarsan

Re: selection criteria in a trigger

jagan — Fri, 02 Mar 2012 13:12:21 GMT

Hi,

Try setting the Search string as

=Max(TOTAL MonthYear)

Regards,

Jagan.