customise the dates showing in the calendar selection in sql editor/dashboard

[hehuan-yu-zen]

Does anybody know whether we could customise the dates showing in the calendar selection in sql editor/dashboard?

My query has a time frame in a particular period, however when I use DateRange parameter in sql editor, it could allow users to choose the dates beyond the particular period. But I want the parameter could be configured to constrain users not to select the dates beyond this particular period. I think this would be more user friendly. Is there any solution I had missed? Hope somebody could help me to solve this.

More sepcifically, let's say we have a date column, its value starts from 23-08-01 and ends at 2023-08-31, so I don't want the calandar could show the dates beyond this time frame OR if the calandar could show the dates beyond this time frame, I don't want users could select the dates beyond this time frame.

[hehuan-yu-zen]

Hi @Retired_mod  thanks for your response. Actually I have already used those date related parameters to show the query results. However my concern is I want to customise the date slider or the calendar picker, 

like in this picture, my data set only have records during the whole November in 2017, so I don't want users could click the dates beyond this range, so I want a feature like a 'banning' logo to show users that they cannot pick the dates beyond this range.