Question
Shell India market private limited
IN
Last activity: 24 Apr 2023 11:33 EDT
Filter Years Dynamically
How to display next 5 years dynamically in dropdown based on current year.
My Scenario: I have one report under Reports navigation pane.
1.If user select that particular report today (current date) then the Yearly dropdown filed should allow user to choose the years next five years, 2023, 24,25,26,27.
2. Suppose i am in date "April 24 2024" and i have clicked on the report then user should able to see the dropdown for following 5 years from 2024, like 2024,25,26,27,28.
Please advise if there anyway to achieve this functionality. Also i have attached the screen shot.