# KIBANA DSL Date filtering using timepicker picked date range

**URL:** <https://discuss.elastic.co/t/kibana-dsl-date-filtering-using-timepicker-picked-date-range/55658>\
**Category:** Kibana\
**Created:** [July 15, 2016, 9:13pm UTC](https://discuss.elastic.co/t/kibana-dsl-date-filtering-using-timepicker-picked-date-range/55658 "2016-07-15T21:13:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rokasat](https://avatars.discourse-cdn.com/v4/letter/r/ebca7d/32.png) [@rokasat](https://discuss.elastic.co/u/rokasat)\
**Post date:** [July 15, 2016, 9:13pm UTC](https://discuss.elastic.co/t/kibana-dsl-date-filtering-using-timepicker-picked-date-range/55658/1 "2016-07-15T21:13:29Z")

</div>

Is it possible to use Kibana selected date range in dsl query,  
eg: If you look at following query I need the "kibana selected lower timestamp"  
field to take kibana timepicker selected time range.

```
{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "endTime": {
              "gte": "<kibana selected lower timestamp>"
            }
          }
        },
        {
          "range": {
            "endTime": {
              "lte": "<kibana selected upper timestamp>"
            }
          }
        },
        {
          "range": {
            "startTime": {
              "lte": "<kibana selected upper timestamp>"
            }
          }
        }
      ]
    }
  }
}
```

---

<div class="post-metadata">

**Author:** ![shaunak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shaunak/32/6643_2.png) [@shaunak](https://discuss.elastic.co/u/shaunak)\
**Post date:** [July 18, 2016, 6:16pm UTC](https://discuss.elastic.co/t/kibana-dsl-date-filtering-using-timepicker-picked-date-range/55658/2 "2016-07-18T18:16:40Z")

</div>

Where are you trying to run this query from?

I ask because Kibana will automatically insert the timepicker ranges into each search query it makes to Elasticsearch to retrieve data from the selected index pattern for visualizing it. Specifically, Kibana will add the following `must` clause to each search query:

```
{
  "range": {
    "@timestamp": {
      "gte": <kibana selected lower timestamp>,
      "lte": <kibana selected upper timestamp>,
      "format": "epoch_millis"
    }
  }
}
```

---

<div class="post-metadata">

**Author:** ![rokasat](https://avatars.discourse-cdn.com/v4/letter/r/ebca7d/32.png) [@rokasat](https://discuss.elastic.co/u/rokasat)\
**Post date:** [July 20, 2016, 4:37pm UTC](https://discuss.elastic.co/t/kibana-dsl-date-filtering-using-timepicker-picked-date-range/55658/3 "2016-07-20T16:37:44Z")

</div>

I am using regular kibana search bar to search with elastic search queries. please check my query it shows why I need this timestamp separately.

---

<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:** [July 6, 2017, 1:45pm UTC](https://discuss.elastic.co/t/kibana-dsl-date-filtering-using-timepicker-picked-date-range/55658/4 "2017-07-06T13:45:26Z")

</div>