Current year as default selection

[#1]

Hi All,

I need the current year to be automatically selected when a user opens the report. I have tried using the Document Properties > Triggers > OnOpen but that didn't work for me. Can anyone give me some pointers on how to do this? Maybe an example?

Thanks.

[alexandros17]

Right place,

in the actions select add, then "Select in field" and write in the upper box: year (your field name)

in the lower box: =year(today())

let me know

[sasikanth]

HI ,

Please find the attachment ,

i have enabled both Document level as well as Sheet level

[#4]

Thank you for your response. For some reason, it does not work. I have attached the image of what it looks like. Can you please check? Thanks.

[sasikanth]

Hi

There field Should be

Year([Budget Year Description])

searching string is

=max(Year([Budget Year Description]))

Make sure "Year([Budget Year Description])" is your Year Field

[#6]

Hi, I worked with your example and it did not work either. Attached is the image. Any suggestions?

My data looks like FY13, FY14, FY15. Could it be because the data is not only integers?

Thanks.

[sasikanth]

hi ,

post your sample file

[sasikanth · Accepted solution]

Intead max overthere

use

maxstring([Budget Year Description])

[alexandros17]

IN the field write only

[Budget Year Description]

[#10]

Hi Alessandro and Sasikanth, thanks for your help. I got it working using:

Field: [Budget Year Description]

Search String: =maxstring([Budget Year Description])

It also worked with Budget Year ID.

Thanks again.