# Query documents using multiple time fields

**URL:** https://discuss.elastic.co/t/query-documents-using-multiple-time-fields/89857
**Category:** Kibana
**Created:** [June 18, 2017, 4:30pm UTC](https://discuss.elastic.co/t/query-documents-using-multiple-time-fields/89857 "2017-06-18T16:30:14Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![shaharmor](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@shaharmor](https://discuss.elastic.co/u/shaharmor)
#### Post date: [June 18, 2017, 4:30pm UTC](https://discuss.elastic.co/t/query-documents-using-multiple-time-fields/89857/1 "2017-06-18T16:30:14Z")

</div>

Hi,

I know that today its possible to query for documents using a specific single time field, but I was wondering if its possible to query for documents that the query time range falls between two other time fields.

Example:  
Lets say I have a document that have a document that represents a user sessions like this:

```auto
{
  startTime: "2017-06-07T08:30:00.000Z",
  endTime: "2017-06-07T09:30:00.000Z"
}

```

---

<div class="post-metadata">

### Author: ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [June 19, 2017, 8:19pm UTC](https://discuss.elastic.co/t/query-documents-using-multiple-time-fields/89857/2 "2017-06-19T20:19:37Z")

</div>

Yes, I think you can do that in 2 different ways.

In Kibana query bar;

`startTime:[2017-06-07T08:30:00.000Z TO *] AND endTime:[* TO 2017-06-07T09:30:00.000Z]`

Or if you were looking for a range query you could do something like this;

```auto
        {
          "range": {
            "startTime": {
              "gte": "2017-06-14T16:20:04.834Z",
            }
          },
        {
          "range": {
            "endTime": {
              "lt": "2017-06-19T17:24:42.631Z"
            }
          },
        },

```

---

<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 17, 2017, 8:19pm UTC](https://discuss.elastic.co/t/query-documents-using-multiple-time-fields/89857/3 "2017-07-17T20:19:57Z")

</div>

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