Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How did you create month field in the script, using month()?
Try like: =Date(today(),'MMMM')
How did you create month field in the script, using month()?
Try like: =Date(today(),'MMMM')
Thanks Tresesco, it is working fine with your solution.