# Date inserted is translated differenly on Kibana (add 1 hour to date)
**URL:** https://discuss.elastic.co/t/date-inserted-is-translated-differenly-on-kibana-add-1-hour-to-date/155444
**Category:** Kibana
**Created:** [November 5, 2018, 6:59pm UTC](https://discuss.elastic.co/t/date-inserted-is-translated-differenly-on-kibana-add-1-hour-to-date/155444 "2018-11-05T18:59:51Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@toshi78](https://discuss.elastic.co/u/toshi78)
#### Post date: [November 5, 2018, 6:59pm UTC](https://discuss.elastic.co/t/date-inserted-is-translated-differenly-on-kibana-add-1-hour-to-date/155444/1 "2018-11-05T18:59:51Z")
Hi !
I'm experiencing an odd situation with Kibana 6: I've inserted a datetime which is in GMT+1, which appears correclty under the **JSON** tab on Kibana:
> "collectedTime": "2018-11-05 18:17:07Z",
But on the **Table** tab, Kibana added 1 hour to the initial data:
> November 5th 2018, 19:17:07.000
I would understand if it normalize to GMT, but here it added 1 hour, which means the time showed is now GMT+2 instead of GMT+1.
Can someone help me to understand the behavior, and how do I prevent it ?
With many thanks 🙂
---
### Author:  [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [November 5, 2018, 7:02pm UTC](https://discuss.elastic.co/t/date-inserted-is-translated-differenly-on-kibana-add-1-hour-to-date/155444/2 "2018-11-05T19:02:31Z")
What is the setting of `dateFormat:tz` under Management -\> Advanced settings? If it is set to `browser` than Kibana will display the time in your browsers timezone
---
### Author:  [@toshi78](https://discuss.elastic.co/u/toshi78)
#### Post date: [November 5, 2018, 8:07pm UTC](https://discuss.elastic.co/t/date-inserted-is-translated-differenly-on-kibana-add-1-hour-to-date/155444/3 "2018-11-05T20:07:30Z")
Ok, with your advices, I've checked the `dateFormat:tz`, which was "Browser" by default. However, after changed the dateFormat to GMT+1, the date on **Table** still the same, even after restarted Kibana service.
Will it be applied for future insertion only ?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 3, 2018, 8:07pm UTC](https://discuss.elastic.co/t/date-inserted-is-translated-differenly-on-kibana-add-1-hour-to-date/155444/4 "2018-12-03T20:07:45Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.