MAX YEAR

[gauthamchilled]

i have a listbox..

Year

FY2015

MY2015

FY2014

MY2014

I WANT TO CREATE A TRIGGER TO SELECT LATEST OR MAX FIELD FROM THIS LISTBOX..

HOW CAN I  CREATE AN EXPRESSION FOR SELECT IN FIELD TRIGGER TO SELECT MAX YEAR

[gauthamchilled]

Can I avoid *..it is showing  *FY2015 is showing in current selection

[tresB]

Yes. Just try:

=If( Index(Concat({<Year={'*$(vMaxYear)'}>}Year), 'FY'), 'FY'&vMaxYear, 'MY'&vMaxYear)