# How filter range date in CreateDate

**URL:** <https://discuss.elastic.co/t/how-filter-range-date-in-createdate/300844>\
**Category:** Kibana\
**Created:** [March 28, 2022, 12:47pm UTC](https://discuss.elastic.co/t/how-filter-range-date-in-createdate/300844 "2022-03-28T12:47:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Damas\_Mahardi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/damas_mahardi/32/101996_2.png) [@Damas\_Mahardi](https://discuss.elastic.co/u/Damas_Mahardi)\
**Post date:** [March 28, 2022, 12:47pm UTC](https://discuss.elastic.co/t/how-filter-range-date-in-createdate/300844/1 "2022-03-28T12:47:14Z")

</div>

![kibana](https://us1.discourse-cdn.com/elastic/original/3X/1/3/130570b92b3e09d9f80677bc7f4f9b17b30eea58.png)

---

<div class="post-metadata">

**Author:** ![sholzhauer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sholzhauer/32/110282_2.png) [@sholzhauer](https://discuss.elastic.co/u/sholzhauer)\
**Post date:** [March 28, 2022, 2:03pm UTC](https://discuss.elastic.co/t/how-filter-range-date-in-createdate/300844/2 "2022-03-28T14:03:14Z")

</div>

Assuming the field is a `date` field. You can use a DSL (select the top right `edit as Quesry DSL`) to do this.

```auto
{
  "query": {
    "range": {
      "createDate": {
        "gte": "now-30d",
        "lte": "now-20d"
      }
    }
  }
}

```

This would filter to anything between 30 and 20 days ago.

---

<div class="post-metadata">

**Author:** ![Damas\_Mahardi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/damas_mahardi/32/101996_2.png) [@Damas\_Mahardi](https://discuss.elastic.co/u/Damas_Mahardi)\
**Post date:** [March 28, 2022, 11:22pm UTC](https://discuss.elastic.co/t/how-filter-range-date-in-createdate/300844/3 "2022-03-28T23:22:01Z")

</div>

Thanks, But Not working

---

<div class="post-metadata">

**Author:** ![sholzhauer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sholzhauer/32/110282_2.png) [@sholzhauer](https://discuss.elastic.co/u/sholzhauer)\
**Post date:** [March 30, 2022, 6:48am UTC](https://discuss.elastic.co/t/how-filter-range-date-in-createdate/300844/4 "2022-03-30T06:48:06Z")

</div>

How is it not working? Is it just not returning any hits, does it produce an error?  
What is the exact filter you added?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 27, 2022, 6:48am UTC](https://discuss.elastic.co/t/how-filter-range-date-in-createdate/300844/5 "2022-04-27T06:48:54Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.