Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try with this
Search string as =Max(ALL MonthYear)
Celambarsan
Hi,
Try setting the Search string as
=Max(TOTAL MonthYear)
Regards,
Jagan.