# Kibana : failed to parse date field \[1554163200000\] with format \[year\_month\_day\]

**URL:** <https://discuss.elastic.co/t/kibana-failed-to-parse-date-field-1554163200000-with-format-year-month-day/176689>\
**Category:** Kibana\
**Created:** [April 12, 2019, 6:40pm UTC](https://discuss.elastic.co/t/kibana-failed-to-parse-date-field-1554163200000-with-format-year-month-day/176689 "2019-04-12T18:40:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![igour](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igour/32/38679_2.png) [@igour](https://discuss.elastic.co/u/igour)\
**Post date:** [April 12, 2019, 6:40pm UTC](https://discuss.elastic.co/t/kibana-failed-to-parse-date-field-1554163200000-with-format-year-month-day/176689/1 "2019-04-12T18:40:57Z")

</div>

In Kibana, i am able to see date in mentioned format which was very much anticipated.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/9/29d81b1f386ed91aa224dc327d0831653dc84a00.png)

Mapping which I created was type like this:

> "StartDate" : {  
> "type" : "date",  
> "format" : "year\_month\_day"  
> }

Once i select any date from drop down as mentioned, i got he messages like "Failed to parse date filed with mentioned format".

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

Let me know how i can set the mapping and other things, so that from drop down also i should able to get the human readable date, for easy dashboard experience.

---

<div class="post-metadata">

**Author:** ![igour](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igour/32/38679_2.png) [@igour](https://discuss.elastic.co/u/igour)\
**Post date:** [April 13, 2019, 6:29am UTC](https://discuss.elastic.co/t/kibana-failed-to-parse-date-field-1554163200000-with-format-year-month-day/176689/2 "2019-04-13T06:29:00Z")

</div>

From @Elastic team can anyone help

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [April 15, 2019, 5:21pm UTC](https://discuss.elastic.co/t/kibana-failed-to-parse-date-field-1554163200000-with-format-year-month-day/176689/3 "2019-04-15T17:21:19Z")

</div>

Hi,  
I see that your mapping does not have a time component. In general Kibana does not handle date fields without a time component well. We have sort of a meta issue for it here [#10575](https://github.com/elastic/kibana/issues/10575)

Further more you can read about date formats here: [https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html)

Also you should take a look at [http://localhost:9200/\_mapping](http://localhost:9200/_mapping) and ensure your field is being correctly mapped to a date type with the correct format.

Thanks  
Rashmi

---

<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:** [May 13, 2019, 5:21pm UTC](https://discuss.elastic.co/t/kibana-failed-to-parse-date-field-1554163200000-with-format-year-month-day/176689/4 "2019-05-13T17:21:21Z")

</div>

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