# Kibana converts any date and month to a specific date and month

**URL:** https://discuss.elastic.co/t/kibana-converts-any-date-and-month-to-a-specific-date-and-month/272838
**Category:** Kibana
**Created:** [May 12, 2021, 5:18pm UTC](https://discuss.elastic.co/t/kibana-converts-any-date-and-month-to-a-specific-date-and-month/272838 "2021-05-12T17:18:47Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![SUMANT\_MISHRA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sumant_mishra/32/77606_2.png) [@SUMANT\_MISHRA](https://discuss.elastic.co/u/SUMANT_MISHRA)
#### Post date: [May 12, 2021, 5:18pm UTC](https://discuss.elastic.co/t/kibana-converts-any-date-and-month-to-a-specific-date-and-month/272838/1 "2021-05-12T17:18:47Z")

</div>

Hi All, I am facing issues in date format. I have dates in '2021-05-03 23:11:25.84' format. If I create mapping like:

_`{`_  
_` "format": "YYYY-MM-DD HH:mm:ss.SSS||YYYY-MM-DD HH:mm:` `ss.SS` `||YYYY-MM-DD HH:mm:ss.S",`_  
_` "type": "date"`_  
_`}`_

I am getting dates in Kibana like **Jan 4, 2021 @ 23:11:25.840**. Can anyone please guide the right way to handle? Any date I store in elasticsearch Kibana changes that date to 1st Jan and keeps the year and time the same as I stored.

I have tried by changing:

- Timezone for date formatting to _UTC and US/Eastern_
- Date format to _YYYY-MM-DD HH:mm:ss.SSS_

Please suggest

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [May 12, 2021, 11:15pm UTC](https://discuss.elastic.co/t/kibana-converts-any-date-and-month-to-a-specific-date-and-month/272838/2 "2021-05-12T23:15:38Z")

</div>

> [@SUMANT\_MISHRA](#):
>
> I am getting dates in Kibana like **Jan 4, 2021 @ 23:11:25.840**

It'd be helpful if you could provide an example of the data that you sending to Elasticsearch, and then the actual json document directly from Elasticsearch.

---

<div class="post-metadata">

### Author: ![SUMANT\_MISHRA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sumant_mishra/32/77606_2.png) [@SUMANT\_MISHRA](https://discuss.elastic.co/u/SUMANT_MISHRA)
#### Post date: [May 13, 2021, 4:13am UTC](https://discuss.elastic.co/t/kibana-converts-any-date-and-month-to-a-specific-date-and-month/272838/3 "2021-05-13T04:13:20Z")

</div>

Hi @warkolm, Here are the screenshots:

**Data I am sending to elasticsearch:**

 ![Screenshot 2021-05-13 at 9.30.14 AM](https://us1.discourse-cdn.com/elastic/original/3X/2/a/2a9f724df1471c9d8dcc2e189dcd47f6aedce598.png)

**Mapping for the index:**

 ![Screenshot 2021-05-13 at 9.30.49 AM](https://us1.discourse-cdn.com/elastic/original/3X/a/a/aa87910cfac946ee2a5cc0313927e705aab25d56.png)

The actual json document directly from Elasticsearch (using DevTools):

 ![Screenshot 2021-05-13 at 9.31.12 AM](https://us1.discourse-cdn.com/elastic/original/3X/7/8/780085d7c7f7c241db3d5aabceaf724fd7def6e1.png)

Kibana output:

 ![Screenshot 2021-05-13 at 9.31.28 AM](https://us1.discourse-cdn.com/elastic/original/3X/4/1/41f70aa7f15f5db77dc84a337d432fc35c047a3b.png)

As I noticed Month and date is being changed if the date contains time.

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [May 13, 2021, 4:17am UTC](https://discuss.elastic.co/t/kibana-converts-any-date-and-month-to-a-specific-date-and-month/272838/4 "2021-05-13T04:17:41Z")

</div>

Please don't post pictures of text, they are difficult to read, impossible to search and replicate (if it's code), and some people may not be even able to see them 🙂

If you can post that Dev tools json, I can try to replicate it as well.

---

<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: [June 10, 2021, 4:18am UTC](https://discuss.elastic.co/t/kibana-converts-any-date-and-month-to-a-specific-date-and-month/272838/5 "2021-06-10T04:18:14Z")

</div>

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