# Filtering by Date

**URL:** https://community.glideapps.com/t/filtering-by-date/1467
**Category:** Ask for Help
**Created:** [October 29, 2019, 2:45am UTC](https://community.glideapps.com/t/filtering-by-date/1467 "2019-10-29T02:45:17Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![Tziri\_Lamm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tziri_lamm/32/1175_2.png) [@Tziri\_Lamm](https://community.glideapps.com/u/Tziri_Lamm)
#### Post date: [October 29, 2019, 2:45am UTC](https://community.glideapps.com/t/filtering-by-date/1467/1 "2019-10-29T02:45:17Z")

</div>

Hi! Brand new user here.

I created a tab called Due Soon and I have a column with a deadline.  
I tried adding a filter but all the time related ones - within, on or before, on or after… only give options for today or now.

What am I doing wrong?

---

<div class="post-metadata">

### Author: ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)
#### Post date: [October 29, 2019, 2:52am UTC](https://community.glideapps.com/t/filtering-by-date/1467/2 "2019-10-29T02:52:32Z")

</div>

Currently you can only filter by comparing dates in each row to today or now. We will have to add more columns for ‘date math’ and allow you to do more complex comparisons before this is possible.

---

<div class="post-metadata">

### Author: ![Tziri\_Lamm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tziri_lamm/32/1175_2.png) [@Tziri\_Lamm](https://community.glideapps.com/u/Tziri_Lamm)
#### Post date: [October 29, 2019, 2:53am UTC](https://community.glideapps.com/t/filtering-by-date/1467/3 "2019-10-29T02:53:47Z")

</div>

Thanks!  
Is there any kind of workaround for me to create an upcoming deadline filter or tab?

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [October 29, 2019, 3:23am UTC](https://community.glideapps.com/t/filtering-by-date/1467/4 "2019-10-29T03:23:09Z")

</div>

Create a column to calculate the number of days till due then use that for the filter.

---

<div class="post-metadata">

### Author: ![Tziri\_Lamm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tziri_lamm/32/1175_2.png) [@Tziri\_Lamm](https://community.glideapps.com/u/Tziri_Lamm)
#### Post date: [October 29, 2019, 10:48am UTC](https://community.glideapps.com/t/filtering-by-date/1467/5 "2019-10-29T10:48:34Z")

</div>

Perfect! Thank you!

---

<div class="post-metadata">

### Author: ![Carlos\_Marchan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_marchan/32/3139_2.png) [@Carlos\_Marchan](https://community.glideapps.com/u/Carlos_Marchan)
#### Post date: [February 2, 2020, 5:06pm UTC](https://community.glideapps.com/t/filtering-by-date/1467/6 "2020-02-02T17:06:13Z")

</div>

Hi George. How can I set this complementary calc-date column to calculate **automatically** the nr of days each time a new row is added?

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [February 2, 2020, 5:34pm UTC](https://community.glideapps.com/t/filtering-by-date/1467/7 "2020-02-02T17:34:14Z")

</div>

Either using ARRAYFORMULA in the gsheet, either using a Math column in the data editor, I think it works for date computations.

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [February 3, 2020, 6:42pm UTC](https://community.glideapps.com/t/filtering-by-date/1467/8 "2020-02-03T18:42:34Z")

</div>

Here you go.

 ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c172b3ae7e609c3bf93cec8ccbd07fad7fe24cd4.png)

---

<div class="post-metadata">

### Author: ![Carlos\_Marchan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_marchan/32/3139_2.png) [@Carlos\_Marchan](https://community.glideapps.com/u/Carlos_Marchan)
#### Post date: [February 3, 2020, 9:19pm UTC](https://community.glideapps.com/t/filtering-by-date/1467/9 "2020-02-03T21:19:09Z")

</div>

Thank you George! Awesome!

---

<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: [March 27, 2024, 10:11am UTC](https://community.glideapps.com/t/filtering-by-date/1467/10 "2024-03-27T10:11:30Z")

</div>