# Why do I need to set times in UTC in the query bar?

**URL:** <https://discuss.elastic.co/t/why-do-i-need-to-set-times-in-utc-in-the-query-bar/194281>\
**Category:** Kibana\
**Created:** [August 7, 2019, 3:56pm UTC](https://discuss.elastic.co/t/why-do-i-need-to-set-times-in-utc-in-the-query-bar/194281 "2019-08-07T15:56:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcaballero](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jcaballero](https://discuss.elastic.co/u/jcaballero)\
**Post date:** [August 7, 2019, 3:56pm UTC](https://discuss.elastic.co/t/why-do-i-need-to-set-times-in-utc-in-the-query-bar/194281/1 "2019-08-07T15:56:41Z")

</div>

Using Kibana 5.4.1

Here are the facts:

- The data I am parsing with LogStash includes some timestamps I need to convert to a new field "my\_datefield".

- Those timestamps are in local time in the logs files.

- I convert them to UTC before putting them in ElasticSearch, using the LogStash filter plugin Date:

- That works, and "my\_datefield" is stored in ElasticSearch in UTC.

- When I visualize the data in Kibana, they are converted properly back to local time, so I see the original values, not the UTC ones. Perfect.

- Problem is when I want to do a filter, like this

Is this unavoidable? Or is it just a matter of adjusting some Kibana configuration parameter?

Thanks a lot in advance.  
Jose

---

<div class="post-metadata">

**Author:** ![jcaballero](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jcaballero](https://discuss.elastic.co/u/jcaballero)\
**Post date:** [August 7, 2019, 7:52pm UTC](https://discuss.elastic.co/t/why-do-i-need-to-set-times-in-utc-in-the-query-bar/194281/2 "2019-08-07T19:52:50Z")

</div>

Hmm... Is just a matter of adding **"time\_zone":"America/New\_York"** to the dictionary **query:queryString:options** in "advanced settings"?

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [August 13, 2019, 11:31pm UTC](https://discuss.elastic.co/t/why-do-i-need-to-set-times-in-utc-in-the-query-bar/194281/3 "2019-08-13T23:31:17Z")

</div>

That should do the trick. Did it work for you?

---

<div class="post-metadata">

**Author:** ![jcaballero](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@jcaballero](https://discuss.elastic.co/u/jcaballero)\
**Post date:** [August 13, 2019, 11:56pm UTC](https://discuss.elastic.co/t/why-do-i-need-to-set-times-in-utc-in-the-query-bar/194281/4 "2019-08-13T23:56:01Z")

</div>

Yes, it did 🙂

---

<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:** [September 10, 2019, 11:56pm UTC](https://discuss.elastic.co/t/why-do-i-need-to-set-times-in-utc-in-the-query-bar/194281/5 "2019-09-10T23:56:07Z")

</div>

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