# Kibana ins't displaying correct dates

**URL:** https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862
**Category:** Kibana
**Created:** [November 22, 2018, 10:55am UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862 "2018-11-22T10:55:17Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Nevox](https://avatars.discourse-cdn.com/v4/letter/n/90db22/32.png) [@Nevox](https://discuss.elastic.co/u/Nevox)
#### Post date: [November 22, 2018, 10:55am UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/1 "2018-11-22T10:55:18Z")

</div>

Hi,

I'm stuck on a problem since 1 or 2 days and i can't get the solution. My problem is with date fields in my data, Kibana isn't displaying the good value of month. There is a difference of 10 months between each equivalent date, i'm quite sure that the problem isn't caused by timezone or date format, I searched a long time on topics but i found no solutions (I may be wrong).  
If someone have an idea that could be cool 😉

Here is the value of my data in elastic (I just masked data confidential & non relevant for this topic) :

![image](https://us1.discourse-cdn.com/elastic/original/3X/c/7/c7b67647c98cbb3e1e9d135bb5f7fb7ff227ed11.png)

Here is the same data in Kibana :

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/3/13970ba595c72404129a9d88dce9d51d0d87b94c.png)

My dates settings on Kibana :

![image](https://us1.discourse-cdn.com/elastic/original/3X/1/f/1f28c8eb5cd4c1396e5eeaebd7bde5314ad8739d.png)

Thanks.

---

<div class="post-metadata">

### Author: ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [November 22, 2018, 12:54pm UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/2 "2018-11-22T12:54:12Z")

</div>

Can you look at the request made by kibana to ES and the answer when the date is not right? And then if you can, post it here, removing the sensitive data that you have.

---

<div class="post-metadata">

### Author: ![Nevox](https://avatars.discourse-cdn.com/v4/letter/n/90db22/32.png) [@Nevox](https://discuss.elastic.co/u/Nevox)
#### Post date: [November 22, 2018, 1:35pm UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/3 "2018-11-22T13:35:46Z")

</div>

Thanks for your response Marius,

I'm new on the ELK stack, Can you tell me where I can get this request and the answer ?

---

<div class="post-metadata">

### Author: ![Nevox](https://avatars.discourse-cdn.com/v4/letter/n/90db22/32.png) [@Nevox](https://discuss.elastic.co/u/Nevox)
#### Post date: [November 26, 2018, 9:14am UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/4 "2018-11-26T09:14:38Z")

</div>

You are maybe talking about this request ?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/f/7f84f04d15c1f65b5835e56a8e8aebcee24fc305.png)

---

<div class="post-metadata">

### Author: ![Nevox](https://avatars.discourse-cdn.com/v4/letter/n/90db22/32.png) [@Nevox](https://discuss.elastic.co/u/Nevox)
#### Post date: [November 29, 2018, 3:33pm UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/5 "2018-11-29T15:33:29Z")

</div>

I think that I found where the problem come from. I tried to recreate my elastic index without any mapping and the dates were the same as the data that I receive. After that I reapplied the index mapping and the error came back.

This is the mapping :

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/2/229d0fbbbc8cf770634ca3d92094a4770de9537a.png)

I tried to delete date format string to only keep the type 'date'. But Elastic return me an error, and I've to set those 3 fields in date type.

Does someone have an idea why the index mapping bring this problem ?

Thanks,  
Nevox

---

<div class="post-metadata">

### Author: ![Nevox](https://avatars.discourse-cdn.com/v4/letter/n/90db22/32.png) [@Nevox](https://discuss.elastic.co/u/Nevox)
#### Post date: [November 30, 2018, 2:25pm UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/6 "2018-11-30T14:25:15Z")

</div>

I discovered new things. I think that its not the mapping itself that cause this problem but Kibana. While searching in Kibana request body, I discovered that Kibana received a 'field' object for each data and in this object contain all the fields that i mapped in date format + the timestamp.

Here is the screenshots of the answer of the request made by Kibana :

![image](https://us1.discourse-cdn.com/elastic/original/3X/9/3/933320b9d5a5fbc416745942ac1d57a5347e2c72.png)

And here the same data in Kibana (Here we can also see the 'Fields' object):

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/1/010821ec6b12baae21c9d98609c27d249020da70.png)

I think that Kibana replace all the date fields values with the values in this object. I don't why because I never tell Elastic to send this object or Kibana to replace the values.

I searched a lot on the internet but I didn't found a similar topic. If someone have an idea of why Kibana is doing that, it would be awesome 😛

Thanks,  
Nevox

---

<div class="post-metadata">

### Author: ![bryan\_stuhlsatz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bryan_stuhlsatz/32/49123_2.png) [@bryan\_stuhlsatz](https://discuss.elastic.co/u/bryan_stuhlsatz)
#### Post date: [December 2, 2018, 6:52am UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/7 "2018-12-02T06:52:48Z")

</div>

You are not using the date format correctly. See: [https://www.elastic.co/guide/en/elasticsearch/reference/1.4/mapping-date-format.html](https://www.elastic.co/guide/en/elasticsearch/reference/1.4/mapping-date-format.html)

dd-MM-yyyy

Also keep in mind that what you see in kibana visualizations timeframe might differ from what you see if you used Dev Tools or a rest client, as the latter will show the epoc time. Kibana will display the time in reference to your timezone.

---

<div class="post-metadata">

### Author: ![Nevox](https://avatars.discourse-cdn.com/v4/letter/n/90db22/32.png) [@Nevox](https://discuss.elastic.co/u/Nevox)
#### Post date: [December 2, 2018, 3:33pm UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/8 "2018-12-02T15:33:13Z")

</div>

Oh yeah you're right, my bad. Thanks a lot for the reply 😉

---

<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: [December 30, 2018, 3:33pm UTC](https://discuss.elastic.co/t/kibana-inst-displaying-correct-dates/157862/9 "2018-12-30T15:33:14Z")

</div>

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