Dynamically Populate Curr+2 years
I have a requirement to dynamically populate current years+ 2 years of data without user input with 0CALYEAR.
Report result should show three years of data.
Please find attached screen shot of the same.
Please suggest best way to populate 3 years of data.
Umashankar Poojar replied
Using Offset option is sufficient to solve your problem, if you have used 0CYEAR+2, then it should show 2015, 2016 & 2017. Have you changed the operator as <= instead of =.
Try using range, between option keep from as 0CYEAR and TO as 0CYEAR+2 (using offset). update