# Kibana apply a timezone math to my datefield

**URL:** <https://discuss.elastic.co/t/kibana-apply-a-timezone-math-to-my-datefield/200482>\
**Category:** Kibana\
**Created:** [September 20, 2019, 7:31pm UTC](https://discuss.elastic.co/t/kibana-apply-a-timezone-math-to-my-datefield/200482 "2019-09-20T19:31:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Denis\_Galvao](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/denis_galvao/32/43409_2.png) [@Denis\_Galvao](https://discuss.elastic.co/u/Denis_Galvao)\
**Post date:** [September 20, 2019, 7:31pm UTC](https://discuss.elastic.co/t/kibana-apply-a-timezone-math-to-my-datefield/200482/1 "2019-09-20T19:31:03Z")

</div>

My datefield is correctly inserted on the elastic docs, but kibana apply a timezone to them.

for ex.:  
datefield on kibana: Sep 20, 2019 @ 13:27:12.000  
datefield on elastic: Sep 20, 2019 @ 16:27:12.000

Is there a way to avoid this timezone filter for this date field?

timestamp is ok, kibana.

My timezone is UTC -3h

Thanks,  
Denis.

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [September 20, 2019, 7:34pm UTC](https://discuss.elastic.co/t/kibana-apply-a-timezone-math-to-my-datefield/200482/2 "2019-09-20T19:34:23Z")

</div>

All timestamp fields in Elasticsearch **must** by convention be in UTC, and Kibana will automatically adjust what is displayed depending on the local timezone. What you have there therefore looks correct. If you are indexing in a different timezone you should adjust this in your ingest pipeline.

---

<div class="post-metadata">

**Author:** ![Denis\_Galvao](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/denis_galvao/32/43409_2.png) [@Denis\_Galvao](https://discuss.elastic.co/u/Denis_Galvao)\
**Post date:** [September 20, 2019, 7:45pm UTC](https://discuss.elastic.co/t/kibana-apply-a-timezone-math-to-my-datefield/200482/3 "2019-09-20T19:45:18Z")

</div>

Thanks. Is there a way to use JSON Input to add 3 hours to the datefiled? I only need to offset 3 hours to the future in some visualisations.

---

<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:** [October 18, 2019, 7:45pm UTC](https://discuss.elastic.co/t/kibana-apply-a-timezone-math-to-my-datefield/200482/4 "2019-10-18T19:45:20Z")

</div>

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