Hi All, I'm ingesting documents to my ES cluster with a field called CREATION_TIME with format Wed, 13 Oct 2021 13:04:54 GMT. I've tried to parse it using below mappings, but Kibana is still ignoring the value. { "properties": { "CREATION_TIME": { "format": "EEE, dd MMM yyyy hh:mm:ss zzz||EEE…

[image] valleram: I'm not getting any error, the problem is that the field is being ignored for some of my documents, even if they have the format I've specified in the mappings. Did you recreate the index with the mapping using HH ? If I'm not wrong hh will get only 01-12 and HH will get 00…

Discuss the Elastic Stack

Parse Date with RFC_1123_DATE_TIME format

Elastic Stack Kibana

leandrojmp (Leandro Pereira) February 17, 2023, 5:05pm 2

What is the error you are getting? Please share the error.

Also, it is HH, not hh for the hour.

Topic		Replies	Views
Date parsing error Elasticsearch	11	2128	August 31, 2017
ElasticSearch mapping date RFC 2822 Elasticsearch	6	1848	July 6, 2017
Problem with date format Mapping Elasticsearch	1	902	July 6, 2017
Date format in Elastic search mapping template creation Elasticsearch	1	617	July 6, 2017
Date time format recognition Elasticsearch	1	290	September 5, 2018

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Parse Date with RFC_1123_DATE_TIME format

Related topics