Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I would like to create variables to reflect current year, previous 12 months (1 year ago), previous 24 months (2 years ago).
How would i write those variables to link with my data for each corresponding year? this would be a big help!
thanks for the help,
Parrish
Hey Parrish:
I have created Master Calendar and Variables to show current and previous years. Master calendar script would be more or less similar for any other app. Then you can create variables and use it calculate desired result. Attached is the qvw and hope this helps you.
Parrish,
I would suggest you to use the Master Calendar following the link mentioned below.
i was under the impression that one could create a formula within a variable that had the capability to determine current year and past year. something like Variable = CurrentYear or Variable = CurrentYear - 1. i am just trying to verify the correct way to write this.
thanks,
Parrish
Hey Parrish:
I have created Master Calendar and Variables to show current and previous years. Master calendar script would be more or less similar for any other app. Then you can create variables and use it calculate desired result. Attached is the qvw and hope this helps you.