on Open

[subbareddykm]

Hi all,

I need one input ,

When i open application My last month should get selected  in YearMotth Field .

Can any one tell me how to do this ?

[techvarun]

Use below script on onopen trigger

=MaxString(YearMonth)

[techvarun]

[tresesco]

=MaxString(Date#(YearMonth, 'YYYY.MM'))

[subbareddykm]

It is not selecting last month, let say if current month is 2017.Nov then it show select 2017 Oct, if it is 2018.Jun then it should select 2018 May i.e.2018.05. etc.

I hope you understood

[tresesco · Accepted solution]

Try:

=Date(AddMonths(today(),-1), 'YYYY.MM')