# Failed to parse date field

**URL:** <https://discuss.elastic.co/t/failed-to-parse-date-field/41481>\
**Category:** Kibana\
**Created:** [February 11, 2016, 12:57pm UTC](https://discuss.elastic.co/t/failed-to-parse-date-field/41481 "2016-02-11T12:57:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Croos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/croos/32/29489_2.png) [@Croos](https://discuss.elastic.co/u/Croos)\
**Post date:** [February 11, 2016, 12:57pm UTC](https://discuss.elastic.co/t/failed-to-parse-date-field/41481/1 "2016-02-11T12:57:43Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/2X/1/17d75a8d9378a92fa8c86cc443d697b4f351aba2.JPG)

When I select a date range, There is a problem occur in filtering. I want a solution for this error.

---

<div class="post-metadata">

**Author:** ![Croos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/croos/32/29489_2.png) [@Croos](https://discuss.elastic.co/u/Croos)\
**Post date:** [February 11, 2016, 1:01pm UTC](https://discuss.elastic.co/t/failed-to-parse-date-field/41481/2 "2016-02-11T13:01:43Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/2X/6/66650f34255a7e34a7b2c8c271b8804401af8039.JPG)

```
Error: Request to Elasticsearch failed: {"error":{"root_cause":[{"type":"parse_exception","reason":"failed to parse date field [1450117800000] with format [yyyy-MM-dd HH:mm:ss]"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"asterisk","node":"OPRQvuJxT1qFXFL29fWhQQ","reason":{"type":"parse_exception","reason":"failed to parse date field [1450117800000] with format [yyyy-MM-dd HH:mm:ss]","caused_by":{"type":"illegal_argument_exception","reason":"Invalid format: \"1450117800000\" is malformed at \"0000\""}}}]}}
    at http://localhost:5601/bundles/kibana.bundle.js:79477:39
    at Function.Promise.try (http://localhost:5601/bundles/commons.bundle.js:60997:23)
    at http://localhost:5601/bundles/commons.bundle.js:60966:31
    at Array.map (native)
    at Function.Promise.map (http://localhost:5601/bundles/commons.bundle.js:60965:31)
    at callResponseHandlers (http://localhost:5601/bundles/kibana.bundle.js:79449:23)
    at http://localhost:5601/bundles/kibana.bundle.js:78954:17
    at processQueue (http://localhost:5601/bundles/commons.bundle.js:42358:29)
    at http://localhost:5601/bundles/commons.bundle.js:42374:28
    at Scope.$eval (http://localhost:5601/bundles/commons.bundle.js:43602:29)
```

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [March 13, 2016, 6:11pm UTC](https://discuss.elastic.co/t/failed-to-parse-date-field/41481/3 "2016-03-13T18:11:30Z")

</div>

Are you still experiencing this issue? What version of Kibana are you using?

---

<div class="post-metadata">

**Author:** ![Croos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/croos/32/29489_2.png) [@Croos](https://discuss.elastic.co/u/Croos)\
**Post date:** [March 14, 2016, 7:01am UTC](https://discuss.elastic.co/t/failed-to-parse-date-field/41481/4 "2016-03-14T07:01:16Z")

</div>

Hi Bragin,  
After a long time..  
I'm using kibana-4.3.1-windows. When I import the data by logstash with timestamp, there is no problem. But when I import my log manually, The above error is occurring.

---

<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:** [July 6, 2017, 1:59pm UTC](https://discuss.elastic.co/t/failed-to-parse-date-field/41481/5 "2017-07-06T13:59:15Z")

</div>