# Date filter for calendar view with ability of picking a date

**URL:** <https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874>\
**Category:** Feature Requests\
**Created:** [January 8, 2021, 4:30am UTC](https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874 "2021-01-08T04:30:55Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![tom414](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tom414/32/19428_2.png) [@tom414](https://community.glideapps.com/u/tom414)\
**Post date:** [January 8, 2021, 4:30am UTC](https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874/1 "2021-01-08T04:30:55Z")

</div>

Hi, let say we have a table with a date column, and I have attached it to a calendar view. If I add a filtering ability, it enumerates the date column and filter based on simple matching. Is there any way we can have a smarter filter like BETWEEN a date D1 and D2? Or something that pops up a calendar (like date picker) and lets the user select a range? Bcoz now is really funny, If in my table I have 100 rows and each of em with different dates, then when user tap on filter they will see all those 100 dates, and they have to select it one by one.

---

<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:** [January 8, 2021, 2:16pm UTC](https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874/2 "2021-01-08T14:16:29Z")

</div>

Here is one way you could do this:

- Create 2 User Specific columns. Call one ‘Start Date’ and the other ‘End Date’
- Add 2 Date input components to your screen. One should write to the Start Date column, and the other should write to the End Date column.
- Now you can create a visibility condition like this:

 ![Screen Shot 2021-01-08 at 10.13.38 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/7884edbe1ce3ee386ecc7033662f99d58c781fe8.png)

---

<div class="post-metadata">

**Author:** ![tom414](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tom414/32/19428_2.png) [@tom414](https://community.glideapps.com/u/tom414)\
**Post date:** [January 8, 2021, 3:31pm UTC](https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874/3 "2021-01-08T15:31:34Z")

</div>

Beautiful 🤩 so basically you mean I make my own filter UI, not use the built in filter ability. Right? Nice 👍

---

<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:** [January 8, 2021, 3:38pm UTC](https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874/4 "2021-01-08T15:38:06Z")

</div>

Yes.  
There is one downside with that solution.  
Let’s assume you’re using it to filter an inline list… the downside is that _zero_ records will be displayed until the user has entered both a start date AND an end date. Which could be a little confusing.

A way around this would be to duplicate your inline list, remove the filtering on the second list (so it always displays all records), and then use visibility conditions to display either the first or second list based on the state of the date input components. ie:

- if both are not empty, show the first (filtered) list. Otherwise show the second list.

---

<div class="post-metadata">

**Author:** ![tom414](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tom414/32/19428_2.png) [@tom414](https://community.glideapps.com/u/tom414)\
**Post date:** [January 9, 2021, 10:59am UTC](https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874/5 "2021-01-09T10:59:27Z")

</div>

Fantastic! I did it, including your suggestion about visibility condition. I hope they add new date picker components, such as DateRange picker, anyway Thanks @Darren_Murphy for the hint.

---

<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:** [January 10, 2021, 12:25pm UTC](https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874/6 "2021-01-10T12:25:43Z")

</div>

> [@tom414](#):
>
> I hope they add new date picker components, such as DateRange picker,

Sorry, I missed this the first time.  
This already exists. It’s called an Event Picker.

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

---

<div class="post-metadata">

**Author:** ![tom414](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tom414/32/19428_2.png) [@tom414](https://community.glideapps.com/u/tom414)\
**Post date:** [January 10, 2021, 2:21pm UTC](https://community.glideapps.com/t/date-filter-for-calendar-view-with-ability-of-picking-a-date/20874/7 "2021-01-10T14:21:54Z")

</div>

Awesome, many thx, I guess this week I will go through entire of documentation 😄
