# Date picker - Gray out holidays

**URL:** <https://community.glideapps.com/t/date-picker-gray-out-holidays/38176>\
**Category:** Feature Requests\
**Created:** [February 6, 2022, 5:31am UTC](https://community.glideapps.com/t/date-picker-gray-out-holidays/38176 "2022-02-06T05:31:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\
**Post date:** [February 6, 2022, 5:31am UTC](https://community.glideapps.com/t/date-picker-gray-out-holidays/38176/1 "2022-02-06T05:31:22Z")

</div>

Hi,  
Is there a way to gray-out/filter dates on the date picker? For example, gray out holidays based on a Google Sheet (or even better, based directly on a Google Calendar)?  
I saw @Robert_Petitto’s [post](https://community.glideapps.com/t/filter-on-date-picker/23160/3) in which I believe a similar matter has been implemented, but I’m not sure.  
Ideas?  
Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 6, 2022, 5:48am UTC](https://community.glideapps.com/t/date-picker-gray-out-holidays/38176/2 "2022-02-06T05:48:14Z")

</div>

The post that you linked to is the option that allows you to restrict the date ranges with the date picker.

![Screen Shot 2022-02-06 at 1.36.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/7/474f9c7f58df276f6896989721fe85e35210bf73.png)

There is no way to prevent a user from selecting specific dates, as far as I’m aware. It _might_ be possible with CSS, but I can’t say for sure.

One option you do have (if using a custom form) is to catch “invalid” dates in real time and show appropriate warning messages - and prevent saving - if they don’t meet specific criteria.

Here is an example of what can be done:

The above example doesn’t stop the user from selecting dates that you don’t want them to. But it does warn them when they do, and prevent them from saving.

---

<div class="post-metadata">

**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\
**Post date:** [February 6, 2022, 6:23am UTC](https://community.glideapps.com/t/date-picker-gray-out-holidays/38176/3 "2022-02-06T06:23:55Z")

</div>

Thanks Darren,  
Indeed a good workaround. However, I think a more elegant solution is required. I’ll open a Feature Request.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [February 6, 2022, 3:42pm UTC](https://community.glideapps.com/t/date-picker-gray-out-holidays/38176/4 "2022-02-06T15:42:32Z")

</div>

Hola,

So far and natively, there is no way to filter the holidays in Date Picker, it’s an unnecessary headache when we try to work with 2 dates (In/Out).

My workaround looks like this and can block the holidays set by me earlier:

> **[Book with Us](https://book-us.glideapp.io/)**
>
> A booking app to events or meetings

Saludos!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 6, 2022, 8:37pm UTC](https://community.glideapps.com/t/date-picker-gray-out-holidays/38176/5 "2022-02-06T20:37:33Z")

</div>

Would love there to be a native filter that would grey out dates based on a condition. Seems like Glide is halfway there. A more elegant solution is certainly desired. @Mark