How can i setting up calender up to date

[gzmtpck]

hi, in my date slider i have five years horizon. Then i need to select time interval. the right side of calendar need to have "up to date" i mean "today's date" option. How can i do that?

Thank you for your answers.

[ziyabikram96]

please share screenshot for clarification

[gzmtpck]

the right side of my slicer need to have an option as today's date. For now i am setting it manually

[Anonymous · Accepted solution]

Hi @gzmtpck ,

You can create a calculated column to determine if the date is today, and if so, display it as Y, less than today's N, and the rest as blank. Then set a page or report level filter to filter the data as shown in the figure below. Please find the details in the attachment.

Best Regards