# Date field display issue in Kibana **URL:** \ **Category:** Kibana\ **Created:** [August 2, 2017, 9:33am UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495 "2017-08-02T09:33:14Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Ashish\_Barnwal](https://avatars.discourse-cdn.com/v4/letter/a/f1d935/32.png) [@Ashish\_Barnwal](https://discuss.elastic.co/u/Ashish_Barnwal)\ **Post date:** [August 2, 2017, 9:33am UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/1 "2017-08-02T09:33:14Z")
Dear All, 2 hours is getting added automatically in a date field ( yyyy-MM-dd HH:mm:ss) value while displaying the data in Kibana. However JSON value for that entry is displayed correctly in Kibana. For e.g., data pushed to Elastic search : 2017-08-02 02:04:02 Data shown in Kibana search: 2017-08-02 04:04:02 I have also changed the date format timezone (dateFormat:tz) in advance settings but result is still the same. Can you please suggest how these two can be in sync. Thanks, Ashish ---
**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 2, 2017, 4:47pm UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/2 "2017-08-02T16:47:56Z")
If you go to Dev Tools, Console and manually make a request for the data in Elasticsearch, you see the first value, correct? ---
**Author:** ![Ashish\_Barnwal](https://avatars.discourse-cdn.com/v4/letter/a/f1d935/32.png) [@Ashish\_Barnwal](https://discuss.elastic.co/u/Ashish_Barnwal)\ **Post date:** [August 2, 2017, 5:06pm UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/3 "2017-08-02T17:06:26Z")
Yes thats correct. ---
**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 2, 2017, 5:23pm UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/4 "2017-08-02T17:23:38Z")
Which time zone are you selecting for the `dateFormat:tz`, what is your browser timezone, and what is the timezone of the server running elasticsearch? ---
**Author:** ![Ashish\_Barnwal](https://avatars.discourse-cdn.com/v4/letter/a/f1d935/32.png) [@Ashish\_Barnwal](https://discuss.elastic.co/u/Ashish_Barnwal)\ **Post date:** [August 3, 2017, 7:11am UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/5 "2017-08-03T07:11:03Z")
For dateFormat:tz, I have selected Europe/Amsterdam as timezone. I believe browser timezone will be same as the timezone of the machine where its hosted. Timezone of that machine is also CET (amsterdam). Elastic search is hosted on the same machine. ---
**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 3, 2017, 4:43pm UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/6 "2017-08-03T16:43:58Z")
My guess is that, since you're not sending the time zone in the date you send to Elasticsearch, then it's assumed that the dates are in UTC time. Then, when you view the dates in Kibana, it is translating them into your local time. If you'd like them to be in sync, I'd suggest including the time zone in the dates you're sending to Elasticsearch. ---
**Author:** ![Ashish\_Barnwal](https://avatars.discourse-cdn.com/v4/letter/a/f1d935/32.png) [@Ashish\_Barnwal](https://discuss.elastic.co/u/Ashish_Barnwal)\ **Post date:** [August 4, 2017, 2:35pm UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/7 "2017-08-04T14:35:35Z")
Thanks. Yes you are right! I have now changed the format of my date field to custom format yyyy-MM-dd'T'HH:mm:ssz to support timezone however its not able to recognize CET, IST, EET etc... it only recognizes few like UTC, PST etc... Do you know by any chance what is the format supported for Europe/Amsterdam. ---
**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 4, 2017, 4:51pm UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/8 "2017-08-04T16:51:11Z")
You could use an offset instead of the zone name, such as `+0200` instead. Could you give that a try? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 1, 2017, 4:51pm UTC](https://discuss.elastic.co/t/date-field-display-issue-in-kibana/95495/9 "2017-09-01T16:51:19Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.