# Date format exception with elasticsearch version 6.7.0

**URL:** https://discuss.elastic.co/t/date-format-exception-with-elasticsearch-version-6-7-0/235641
**Category:** Elasticsearch
**Created:** [June 3, 2020, 9:56pm UTC](https://discuss.elastic.co/t/date-format-exception-with-elasticsearch-version-6-7-0/235641 "2020-06-03T21:56:46Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![momo94](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@momo94](https://discuss.elastic.co/u/momo94)
#### Post date: [June 3, 2020, 9:56pm UTC](https://discuss.elastic.co/t/date-format-exception-with-elasticsearch-version-6-7-0/235641/1 "2020-06-03T21:56:46Z")

</div>

I am using the following date format below but my elastic search version complains that it cannot parse the date. Below you will find an example mapping. This is a spring-boot application.

Elasticsearch Version of spring-app: `6.7.0`  
Elasticsearch Version running on docker container `6.3.2`

I am using the following pattern on the `theDate` field.  
`yyyy-MM-dd'T'HH:mm:ss.SSSX`

Example Mapping:

```
 "theDate": {
      "type": "date",
      "format": "yyyy-MM-dd'''T'''HH:mm:SSSX"
    }

```

Exception  
`{"error":{"root_cause":[{"type":"mapper_parsing_exception","reason":"failed to parse [theDate]"}],"type":"mapper_parsing_exception","reason":"failed to parse [dateCreated]","caused_by":{"type":"illegal_argument_exception","reason":"Invalid format: \"1999-06-03T18:12:04.650Z\" is malformed at \"T18:12:04.650Z\""}},"status":400}`

---

<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 1, 2020, 9:56pm UTC](https://discuss.elastic.co/t/date-format-exception-with-elasticsearch-version-6-7-0/235641/2 "2020-07-01T21:56:59Z")

</div>

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