How to define current year and current month onopen to tab

[venkatbza]

Hi Friends,

I have Year and month Name columns. my requirement is when ever I open a tab current year and current month need to select by default.

I tried using triggers ---> OnOpen it is working for year and not working for month.

In the trigger for month i used expression like =Month(today()). but it is not selecting current month.

I have month name column and don't have month number column. With out month number column is  there any way to over come this issue?

see the below image

Thanks,

Venkat

[tresesco · Accepted solution]

How did you create month field in the script, using month()?

Try like: =Date(today(),'MMMM')

[venkatbza]

Thanks Tresesco, it is working fine with your solution.