https://community.databricks.com/t5/warehousing-analytics/customise-the-dates-showing-in-the-calendar-selection-in-sql/m-p/42356#M870 <P>Does anybody know whether we could customise the dates showing in the calendar selection in sql editor/dashboard?</P><P>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&nbsp;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.</P><P>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.</P> Mon, 28 Aug 2023 01:53:24 GMT hehuan-yu-zen 2023-08-28T01:53:24Z https://community.databricks.com/t5/warehousing-analytics/customise-the-dates-showing-in-the-calendar-selection-in-sql/m-p/42356#M870 <P>Does anybody know whether we could customise the dates showing in the calendar selection in sql editor/dashboard?</P><P>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&nbsp;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.</P><P>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.</P> Mon, 28 Aug 2023 01:53:24 GMT https://community.databricks.com/t5/warehousing-analytics/customise-the-dates-showing-in-the-calendar-selection-in-sql/m-p/42356#M870 hehuan-yu-zen 2023-08-28T01:53:24Z https://community.databricks.com/t5/warehousing-analytics/customise-the-dates-showing-in-the-calendar-selection-in-sql/m-p/44044#M913 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/9">@Retired_mod</a>&nbsp; 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,&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hehuanyuzen_0-1694133433062.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3603iD00F7842F5D48D57/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="hehuanyuzen_0-1694133433062.png" alt="hehuanyuzen_0-1694133433062.png" /></span></P><P>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.</P> Fri, 08 Sep 2023 00:39:36 GMT https://community.databricks.com/t5/warehousing-analytics/customise-the-dates-showing-in-the-calendar-selection-in-sql/m-p/44044#M913 hehuan-yu-zen 2023-09-08T00:39:36Z