# How to filter Date?

**URL:** <https://forum.adalo.com/t/how-to-filter-date/12052>\
**Category:** Database\
**Created:** [April 30, 2021, 1:55pm UTC](https://forum.adalo.com/t/how-to-filter-date/12052 "2021-04-30T13:55:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tom1](https://avatars.discourse-cdn.com/v4/letter/t/b487fb/32.png) [@Tom1](https://forum.adalo.com/u/Tom1)\
**Post date:** [April 30, 2021, 1:55pm UTC](https://forum.adalo.com/t/how-to-filter-date/12052/1 "2021-04-30T13:55:29Z")

</div>

![SharedScreenshot](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/37c70835e5277bbfb5dc4a040c6e3562ee3e6648.jpeg)

Am trying to filter a list only showing records dates are less than 30 days old. But it is not working.

May I know how the date filter works?

---

<div class="post-metadata">

**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\
**Post date:** [April 30, 2021, 1:57pm UTC](https://forum.adalo.com/t/how-to-filter-date/12052/2 "2021-04-30T13:57:00Z")

</div>

Hi Tom,

Could you try it with this is and see if it works:

**Created Date \> is after \> 30 days ago**

---

<div class="post-metadata">

**Author:** ![Tom1](https://avatars.discourse-cdn.com/v4/letter/t/b487fb/32.png) [@Tom1](https://forum.adalo.com/u/Tom1)\
**Post date:** [April 30, 2021, 2:26pm UTC](https://forum.adalo.com/t/how-to-filter-date/12052/3 "2021-04-30T14:26:13Z")

</div>

“is after”, not working too. And worst, record that is 1-day old and 32-days old are appearing on list.

---

<div class="post-metadata">

**Author:** ![Tom1](https://avatars.discourse-cdn.com/v4/letter/t/b487fb/32.png) [@Tom1](https://forum.adalo.com/u/Tom1)\
**Post date:** [April 30, 2021, 4:04pm UTC](https://forum.adalo.com/t/how-to-filter-date/12052/4 "2021-04-30T16:04:31Z")

</div>

Is there something wrong with the date-filter? “is after” was showing 2 records earlier (1-day old and 32 days old). But now it is showing only 1-day old record (32-days is now missing).