# Filter by date

**URL:** <https://community.glideapps.com/t/filter-by-date/13451>\
**Category:** Ask for Help\
**Created:** [August 2, 2020, 2:25pm UTC](https://community.glideapps.com/t/filter-by-date/13451 "2020-08-02T14:25:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ns\_Melaka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ns_melaka/32/10399_2.png) [@Ns\_Melaka](https://community.glideapps.com/u/Ns_Melaka)\
**Post date:** [August 2, 2020, 2:25pm UTC](https://community.glideapps.com/t/filter-by-date/13451/1 "2020-08-02T14:25:00Z")

</div>

Hi,  
I have two TABs in my APP. One is Events and the other Promotions.  
I wanted to filter out the items as soon as the date for the event or promotion is over.  
I can do for the event, which as photo show, allows me to filter the items according to finish date of the event.  
 ![start date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/ca3602af3d3f2f315874caa0009aba6504a223f6.jpeg)

In the promotions TAB, I cannot find the date options for filtering. See photo ![finish date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bd0e2c8e866e978d982cf76c209d44ac6eba8efe.jpeg)

Please advise. Is it related to how we select the date when we input? For event I use date and time, while for promotions I use just date picker. However, I have tried to change promotions’ date picker to be date & time, but the result was still the same; i.e. unable to filter according to date.

Thank you.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 2, 2020, 3:46pm UTC](https://community.glideapps.com/t/filter-by-date/13451/2 "2020-08-02T15:46:06Z")

</div>

Can you verify that when you go to the Data Editor, your promotion column that contains the date is really a “Date & Time” column, or is it text?

---

<div class="post-metadata">

**Author:** ![Ns\_Melaka](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ns_melaka/32/10399_2.png) [@Ns\_Melaka](https://community.glideapps.com/u/Ns_Melaka)\
**Post date:** [August 3, 2020, 3:15am UTC](https://community.glideapps.com/t/filter-by-date/13451/3 "2020-08-03T03:15:50Z")

</div>

Thanks Thinh…promotion column was text, so i have deleted it and added a new column to date…all good now…

thanks for helping out.