# ES 7.3 --- date\_time\_parse\_exception: Text '2020-08-25 11:50:00 AM'

**URL:** <https://discuss.elastic.co/t/es-7-3-date-time-parse-exception-text-2020-08-25-1100-am/246523>\
**Category:** Elasticsearch\
**Created:** [August 26, 2020, 11:26pm UTC](https://discuss.elastic.co/t/es-7-3-date-time-parse-exception-text-2020-08-25-1100-am/246523 "2020-08-26T23:26:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vishal22mehra](https://avatars.discourse-cdn.com/v4/letter/v/94ad74/32.png) [@vishal22mehra](https://discuss.elastic.co/u/vishal22mehra)\
**Post date:** [August 26, 2020, 11:26pm UTC](https://discuss.elastic.co/t/es-7-3-date-time-parse-exception-text-2020-08-25-1100-am/246523/1 "2020-08-26T23:26:30Z")

</div>

Hi All,  
I am getting following error message  
"failed to parse date field [**2020-08-25 11:50:00 AM**] with format [uuuu-MM-dd HH:mm:ss:SSS||uuuu-MM-dd HH:mm a||uuuu-MM-dd HH:mm:ss|| **uuuu-MM-dd HH:mm:ss a** ||uuuu-MM-dd||epoch\_millis||MM-dd-uuuu]: [Text '2020-08-25 11:50:00 AM' could not be parsed, unparsed text found at index 19]"  
when running query on ES index. I am not figure it out that when i am providing specific format for date type and passing value as per format than why i am getting this issue.

**ES Version** : 7.3  
**Index Mapping:**  
PUT temp\_duty  
{  
"mappings" : {  
"properties" : {  
"order\_date\_time" :  
{"type":"date","format":"uuuu-MM-dd HH:mm:ss:SSS||uuuu-MM-dd HH:mm a||uuuu-MM-dd HH:mm:ss a||uuuu-MM-d HH:mm:ss||epoch\_millis||uuuu-MM-dd||MM-dd-uuuu"}  
}  
}  
}  
**Note:-** i also tried with following mapping as well  
"type":"date","format":"yyyy-MM-dd HH:mm:ss:SSS||yyyy-MM-dd HH:mm a||yyyy-MM-dd HH:mm:ss a||yyyy-MM-d HH:mm:ss||epoch\_millis||yyyy-MM-dd||MM-dd-yyyy"}

---

<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:** [September 23, 2020, 11:26pm UTC](https://discuss.elastic.co/t/es-7-3-date-time-parse-exception-text-2020-08-25-1100-am/246523/2 "2020-09-23T23:26:40Z")

</div>

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