# Date parsing error in ES - Invalid format

**URL:** <https://discuss.elastic.co/t/date-parsing-error-in-es-invalid-format/137067>\
**Category:** Elasticsearch\
**Created:** [June 22, 2018, 6:30pm UTC](https://discuss.elastic.co/t/date-parsing-error-in-es-invalid-format/137067 "2018-06-22T18:30:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ishantanu](https://avatars.discourse-cdn.com/v4/letter/i/da6949/32.png) [@ishantanu](https://discuss.elastic.co/u/ishantanu)\
**Post date:** [June 22, 2018, 6:30pm UTC](https://discuss.elastic.co/t/date-parsing-error-in-es-invalid-format/137067/1 "2018-06-22T18:30:37Z")

</div>

Hi,

I am facing issue regarding parsing date field in ES. Here's what I am seeing in ES logs for the date:

```auto
Caused by: java.lang.IllegalArgumentException: Invalid format: "04:08:02" is malformed at ":08:02"
        at org.joda.time.format.DateTimeParserBucket.doParseMillis(DateTimeParserBucket.java:187) ~[joda-time-2.9.9.jar:2.9.9]
        at org.joda.time.format.DateTimeFormatter.parseMillis(DateTimeFormatter.java:826) ~[joda-time-2.9.9.jar:2.9.9]
        at org.elasticsearch.index.mapper.DateFieldMapper$DateFieldType.parse(DateFieldMapper.java:248) ~[elasticsearch-6.2.4.jar:6.2.4]
        at org.elasticsearch.index.mapper.DateFieldMapper.parseCreateField(DateFieldMapper.java:456) ~[elasticsearch-6.2.4.jar:6.2.4]
        at org.elasticsearch.index.mapper.FieldMapper.parse(FieldMapper.java:297) ~[elasticsearch-6.2.4.jar:6.2.4]
        ... 57 more

```

This all started from here - [Unable to convert field to date type with date filter](https://discuss.elastic.co/t/unable-to-convert-field-to-date-type-with-date-filter/137018/7)

This is what an example date field's value looks like - `June 17th 2018, 09:45:57.000`

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 23, 2018, 8:12am UTC](https://discuss.elastic.co/t/date-parsing-error-in-es-invalid-format/137067/2 "2018-06-23T08:12:29Z")

</div>

`04:08:02` is indeed not a valid date.

You need probably to make sure you are sending a full date to elasticsearch and not only the time.

I believe this is better to keep this conversation in [Unable to convert field to date type with date filter](https://discuss.elastic.co/t/unable-to-convert-field-to-date-type-with-date-filter/137018/7).

---

<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 21, 2018, 8:13am UTC](https://discuss.elastic.co/t/date-parsing-error-in-es-invalid-format/137067/3 "2018-07-21T08:13:43Z")

</div>

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