# Kibana date format mapping

**URL:** <https://discuss.elastic.co/t/kibana-date-format-mapping/287597>\
**Category:** Kibana\
**Created:** [October 25, 2021, 3:09pm UTC](https://discuss.elastic.co/t/kibana-date-format-mapping/287597 "2021-10-25T15:09:31Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohsin106](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohsin106/32/65203_2.png) [@mohsin106](https://discuss.elastic.co/u/mohsin106)\
**Post date:** [October 25, 2021, 3:09pm UTC](https://discuss.elastic.co/t/kibana-date-format-mapping/287597/1 "2021-10-25T15:09:31Z")

</div>

Hi,

I'm trying to configure a template inside Kibana for a date field but I don't see a date format that matches it.  
My date field looks like this: **2021-05-05 09:38:47 +0000 UTC**  
If I map the date field as "text" inside Kibaba, then Logstash stops complaining. But I want to be able to properly map it. Is there a way to do this?

Thank you.

---

<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:** [October 25, 2021, 10:24pm UTC](https://discuss.elastic.co/t/kibana-date-format-mapping/287597/2 "2021-10-25T22:24:36Z")

</div>

You will need to define your own format for that one - [format | Elasticsearch Guide [7.15] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/7.15/mapping-date-format.html#custom-date-formats)

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [October 25, 2021, 10:25pm UTC](https://discuss.elastic.co/t/kibana-date-format-mapping/287597/3 "2021-10-25T22:25:03Z")

</div>

Did you look at field formatters and date settings in advanced settings in Kibana?

> **[Manage index pattern data fields | Kibana Guide \[7.15\] | Elastic](https://www.elastic.co/guide/en/kibana/current/managing-index-patterns.html#field-formatters-date)**

and Kibana advanced settings - [Advanced Settings | Kibana Guide [7.15] | Elastic](https://www.elastic.co/guide/en/kibana/current/advanced-options.html)

Thanks  
Bhavya

---

<div class="post-metadata">

**Author:** ![mohsin106](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohsin106/32/65203_2.png) [@mohsin106](https://discuss.elastic.co/u/mohsin106)\
**Post date:** [October 29, 2021, 1:43pm UTC](https://discuss.elastic.co/t/kibana-date-format-mapping/287597/4 "2021-10-29T13:43:38Z")

</div>

@warkolm , how can i assign my own date format? when i try to edit the template i'm not able to put my own format in:

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

---

<div class="post-metadata">

**Author:** ![mohsin106](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohsin106/32/65203_2.png) [@mohsin106](https://discuss.elastic.co/u/mohsin106)\
**Post date:** [October 29, 2021, 1:49pm UTC](https://discuss.elastic.co/t/kibana-date-format-mapping/287597/5 "2021-10-29T13:49:39Z")

</div>

Following the notes [here](https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html), I think my date format needs to look like this "yyyy-MM-dd HH:mm:ss +ZZZ z"

---

<div class="post-metadata">

**Author:** ![mohsin106](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohsin106/32/65203_2.png) [@mohsin106](https://discuss.elastic.co/u/mohsin106)\
**Post date:** [October 29, 2021, 1:58pm UTC](https://discuss.elastic.co/t/kibana-date-format-mapping/287597/6 "2021-10-29T13:58:54Z")

</div>

@bhavyarm I tried following along, but I don't see how I can get a specific field in my data set to be formatted with a custom date format. I believe my date format needs to looks like this ""yyyy-MM-dd HH:mm:ss +ZZZ z". I think if I make Date Format changes in the Advanced Setting this will end up affecting how the @timestamp field will get displayed.

---

<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:** [November 26, 2021, 1:58pm UTC](https://discuss.elastic.co/t/kibana-date-format-mapping/287597/7 "2021-11-26T13:58:55Z")

</div>

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