Max(MonthYear)-2 help

[mahitham]

Hi Experts,

Can any one please help me to apply  jan 2019 as default selection in the below extension.

I have tried like Max(MonthYear)-2 but its not showing Jan 2019 as default month. Please help me on this.

Thanks in advance

[sunny_talwar · Accepted solution]

How did you create the Month field in the script? May be one of these

=Date(MonthStart(Max(MonthYear), -2), 'MMM YYYY')

or

=MonthName(MonthStart(Max(MonthYear), -2))