Document on Open show current month and year

[prabunakil]

Hi , can i check how we define the document to open and show the latest current month and year. 

My month field is as per below:

MonthWord:
LOAD * INLINE [
TransactionMonth, TransactionMonth1
04, 01.APR
05, 02.MAY
06, 03.JUN
07, 04.JUL
08, 05.AUG
09, 06.SEP
10, 07.OCT
11, 08.NOV
12, 09.DEC
01, 10.JAN
02, 11.FEB
03, 12.MAR

];

My Fiscal  Year is like

2015/2016

2016/2017

2017/2018

2018/2019

Please help. 

[uacg0009]

Hi Prabunakil,

1.Click "Settings"

2.Choose "Document Properties"

3.Choose "Triggers" tab

You can find a "OnOpen" selection in Document Event Triggers

And you can add actions that you want like a button.

Thanks.

Aiolos

[prabunakil]

Hi Aiolos 

I am following the on event, but the month did not take effect. Please advise it. 

[uacg0009]

Hi,
what kind of value in in your "month" column?
could you please give a sample?
and today is in December, so you want to show December right?

[prabunakil]

Hi

My value in month is 

01 02 03 04 05 06 07 08 09 10 11 12

Yes showing December and year is 2018

[uacg0009 · Accepted solution]

Hi,
I think you can create 2 "selection in field" actions in onopen, one for year, another for month.
For "month",
Field is your month field name
Search String : =num(month(Today()))
Please try.
Aiolos Zhao