# Multiple date format failes

**URL:** <https://discuss.elastic.co/t/multiple-date-format-failes/272100>\
**Category:** Elasticsearch\
**Created:** [May 4, 2021, 5:52pm UTC](https://discuss.elastic.co/t/multiple-date-format-failes/272100 "2021-05-04T17:52:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![telebh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/telebh/32/42272_2.png) [@telebh](https://discuss.elastic.co/u/telebh)\
**Post date:** [May 4, 2021, 5:52pm UTC](https://discuss.elastic.co/t/multiple-date-format-failes/272100/1 "2021-05-04T17:52:24Z")

</div>

Hi .. I have mapping for a date field set as follows. ES version used 7.9

```auto
"itemtransactionid":
							{
							   "type": "date",
							   "format": "yyyy-MM-dd'T'HH:mm:ss:SSZ||strict_date_optional_time||yyyy-MM-dd'T'HH:mm:ss:SSSSZ||yyyy-MM-dd'T'HH:mm:ss:SSSSSZ||yyyy-MM-dd'T'HH:mm:ss.SSSSSSZ"
							},

```

Though when indexing data, I keep getting an exception about parsing as follows

```auto
doc: aff_M48ab99101774949165dM752f1017816596 with status: 400 and result: null failed to index/delete to/from ES!!!!ES Index response: {"took":3,"errors":true,"items":[{"index":{"_index":"affiliation","_type":"_doc","_id":"aff_M48ab99101774949165dM752f1017816596","status":400,"error":{"type":"mapper_parsing_exception","reason":"failed to parse field [docproperties.itemtransactionid] of type [date] in document with id 'aff_M48ab99101774949165dM752f1017816596'. Preview of field's value: '2021-01-13T14:45:23:610063Z'","caused_by":{"type":"illegal_argument_exception","reason":"failed to parse date field [2021-01-13T14:45:23:610063Z] with format [yyyy-MM-dd'T'HH:mm:ss:SSZ||strict_date_optional_time||yyyy-MM-dd'T'HH:mm:ss:SSSSZ||yyyy-MM-dd'T'HH:mm:ss:SSSSSZ||yyyy-MM-dd'T'HH:mm:ss.SSSSSSZ]","caused_by":{"type":"date_time_parse_exception","reason":"Failed to parse with all enclosed parsers"}}}}},{"index":{"_index":"affiliation","_type":"_doc","_id":"aff_M14e66abd15fb6f68adaM7ffe10178163220","status":400,"error":{"type":"mapper_parsing_exception","reason":"failed to parse field [docproperties.itemtransactionid] of type [date] in document with id 'aff_M14e66abd15fb6f68adaM7ffe10178163220'. Preview of field's value: '2017-10-28T21:01:54:874766Z'","caused_by":{"type":"illegal_argument_exception","reason":"failed to parse date field [2017-10-28T21:01:54:874766Z] with format [yyyy-MM-dd'T'HH:mm:ss:SSZ||strict_date_optional_time||yyyy-MM-dd'T'HH:mm:ss:SSSSZ||yyyy-MM-dd'T'HH:mm:ss:SSSSSZ||yyyy-MM-dd'T'HH:mm:ss.SSSSSSZ]","caused_by":{"type":"date_time_parse_exception","reason":"date_time_parse_exception: Failed to parse with all enclosed parsers"}}}}}]}

```

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [May 10, 2021, 9:23am UTC](https://discuss.elastic.co/t/multiple-date-format-failes/272100/2 "2021-05-10T09:23:49Z")

</div>

Try using `X` instead of a `Z` for the timezone. See [DateTimeFormatter (Java SE 11 & JDK 11 )](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/time/format/DateTimeFormatter.html) as a reference,as this includes the `Z` as the default timezone...

---

<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:** [June 7, 2021, 9:23am UTC](https://discuss.elastic.co/t/multiple-date-format-failes/272100/3 "2021-06-07T09:23:52Z")

</div>

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