Need Help on to Show Current Year on Sheet

[#1]

I tried to show the Current year taking last 4 years values. i am unable to show the Current year automatic Selection on Sheet.

I am trying to see the automatic Current Year Selection, When we Open the Sheet. Please help me with this Issue.

[sunny_talwar]

May be add Onsheet triggers. Have you already tried that?

[PabloOrtiz]

Hi,

Try this .qvw,

There is an event when you open de document.

[#4]

i cannot find any Qvw.

[ziadm]

it works on my PC, Once the document opened the year selected is 2016..

what is your QV version

[#6]

i am using 11.2 version

[ziadm]

i did not attach any thing because your original qvw file is working

[#8]

may i know the procedure to Show the Current Year Selection.

[ziadm]

it same version i am using

Try to change the date setting in your script and make it ISO

SET DateFormat='YYYY-MM-DD';

let vYear = Year(Today(0)) ;