Max Day of Max Month

[MK_QSL]

For the enclosed file, when I open the Main Tab, I need the Maximum Day of Maximum Month to be selected by trigger.

I don't want to use Date Field here...

i.e. Max(Date) ...

I need something like

Max Day where Month = Max Month....

Hope I have explained clearly...

[MK_QSL]

I have found the solution....

Trigger

Select in Field

Field = Day

Search String

=Max(IF(Month = Max(All Month), Day))