getting selection for max year and previous month

[kishorj1982]

Need to show default selection for Max years last month(Previous month).Can you please suggest how to go ahead.

Thanks

[dsharmaqv]

look into this

Default max date selection

[#3]

Hi Kishor,

Go to settings>>Document Properties>>Triggers>>Document Event Triggers>>On Open>>Add Actions>>Add>>selection>>Select in field>>enter the field eg(date) and max(date) in Search String

Regards,

Sanya

[kishorj1982]

I have 2 separate field Month and Year

and selection would be March 2017 by default.

Thanks

[dsharmaqv]

So whats the issue?

[chanin7893]

Try This out

Month(AddMonths(Year(Max(Date),-1)))