Trigger - QuarterYear

[NickHoff]

Hello,

I'm attempting to create a trigger on sheet activate to select the Max CalendarQuarterYear, which in the data is formated as 'Q1-2016'.  When I try adding the field CalendarQuarterYear and Search String as Max(CalendarQuarterYear), or MaxString(CalendarQuarterYear) it doesn't work correctly. 

When I add MaxString(CalendarQuarterYear) to a textbox to see the result it doesn't give the latest quarter and year in the data set it gives the selected since the field is always one selected.

[krishnacbe]

try with Max({<CalendarQuarterYear=>}CalendarQuarterYear)

[krishnacbe]

in the textbox.

[NickHoff]

It provides no results.

[krishnacbe]

Try with below expression

=MaxString({<CalendarQuarterYear=>}CalendarQuarterYear)

[NickHoff]

Provides the same results as MaxString(CalendarQuarterYear) which is Q4-2015, the same as the always one selected.

[krishnacbe]

No MaxString(CalendarQuarterYear) is different from MaxString({<CalendarQuarterYear=>}CalendarQuarterYear)

in second expression I am eliminating the selection in CalendarQuarterYear.

see the attached file.

share me sample file and expected output.

[NickHoff]

I know Krishnapriya I tried with both.  I just noticed when I select a month the date changes to the maxstring.  But, month isn't required to be selected.

[NickHoff]

This will show what's happening more clearly.

[krishnacbe]

Try excluding the Month selection in your expression