# Filter by date range

**URL:** <https://forum.bubble.io/t/filter-by-date-range/119427>\
**Category:** Database\
**Created:** [November 4, 2020, 6:08am UTC](https://forum.bubble.io/t/filter-by-date-range/119427 "2020-11-04T06:08:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![flyhigh](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/flyhigh/32/75058_2.png) [@flyhigh](https://forum.bubble.io/u/flyhigh)\
**Post date:** [November 4, 2020, 6:08am UTC](https://forum.bubble.io/t/filter-by-date-range/119427/1 "2020-11-04T06:08:11Z")

</div>

![Bildschirmfoto 2020-11-04 um 06.57.18](https://us1.discourse-cdn.com/bubble/original/3X/0/1/0127431a1617507a1ea276596de116acd2906a25.png)

I want to filter a database based on the **creation date** being **in a range from two date pickers**. Probably it need a date and not a date range how I put it. I also tried “is in” instead of “=”. Not working.

Any hint?

---

<div class="post-metadata">

**Author:** ![ualdir](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ualdir/32/239084_2.png) [@ualdir](https://forum.bubble.io/u/ualdir)\
**Post date:** [November 4, 2020, 10:01am UTC](https://forum.bubble.io/t/filter-by-date-range/119427/2 "2020-11-04T10:01:38Z")

</div>

You have to use type ‘date’ instead ‘date range’. Also you will have the option use \> and \<

---

<div class="post-metadata">

**Author:** ![flyhigh](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/flyhigh/32/75058_2.png) [@flyhigh](https://forum.bubble.io/u/flyhigh)\
**Post date:** [November 4, 2020, 10:27am UTC](https://forum.bubble.io/t/filter-by-date-range/119427/3 "2020-11-04T10:27:36Z")

</div>

Sorry, I don’t understand. Where do I define type ‘date’ ? I am using the Created field in my database.