# Date Field Issue in kibana filtering
**URL:** https://discuss.elastic.co/t/date-field-issue-in-kibana-filtering/218276
**Category:** Elasticsearch
**Created:** [February 7, 2020, 6:05am UTC](https://discuss.elastic.co/t/date-field-issue-in-kibana-filtering/218276 "2020-02-07T06:05:43Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Sangeetha\_Sivaji](https://discuss.elastic.co/u/Sangeetha_Sivaji)
#### Post date: [February 7, 2020, 6:05am UTC](https://discuss.elastic.co/t/date-field-issue-in-kibana-filtering/218276/1 "2020-02-07T06:05:43Z")
Hi,
In kibana, when I tried to filter the date field, it is not filtering and showing the error message. PFB the error.
Error: Request to Elasticsearch failed: {"error":{"root\_cause":[{"type":"parse\_exception","reason":"failed to parse date field [2020-01-28T09:35:02.000Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ]: [failed to parse date field [2020-01-28T09:35:02.000Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ]]"}],"type":"search\_phase\_execution\_exception","reason":"all shards failed","phase":"query","grouped":true,"failed\_shards":[{"shard":0,"index":"jobfailure","node":"n7biTiqiQKmdzXI2zb3-5A","reason":{"type":"query\_shard\_exception","reason":"failed to create query: {\n "bool" : {\n "filter" : [\n {\n "match\_all" : {\n "boost" : 1.0\n }\n },\n {\n "match\_phrase" : {\n "end" : {\n "query" : "2020-01-28T09:35:02.000Z",\n "slop" : 0,\n "zero\_terms\_query" : "NONE",\n "boost" : 1.0\n }\n }\n }\n],\n "adjust\_pure\_negative" : true,\n "boost" : 1.0\n }\n}","index\_uuid":"lXjVYczAQ2G717bCt7aE3Q","index":"jobfailure","caused\_by":{"type":"parse\_exception","reason":"failed to parse date field [2020-01-28T09:35:02.000Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ]: [failed to parse date field [2020-01-28T09:35:02.000Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ]]","caused\_by":{"type":"illegal\_argument\_exception","reason":"failed to parse date field [2020-01-28T09:35:02.000Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ]","caused\_by":{"type":"date\_time\_parse\_exception","reason":"Failed to parse with all enclosed parsers"}}}}}],"caused\_by":{"type":"parse\_exception","reason":"failed to parse date field [2020-01-28T09:35:02.000Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ]: [failed to parse date field [2020-01-28T09:35:02.000Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ]]","caused\_by":{"type":"illegal\_argument\_exception","reason":"failed to parse date field [2020-01-28T09:35:02.000Z] with format [yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ]","caused\_by":{"type":"date\_time\_parse\_exception","reason":"Failed to parse with all enclosed parsers"}}}},"status":400}
at [http://localhost:5601/bundles/commons.bundle.js:3:4897411](http://localhost:5601/bundles/commons.bundle.js:3:4897411)
at Function.\_module.service.Promise.try ([http://localhost:5601/bundles/commons.bundle.js:3:2501410](http://localhost:5601/bundles/commons.bundle.js:3:2501410))
at [http://localhost:5601/bundles/commons.bundle.js:3:2500784](http://localhost:5601/bundles/commons.bundle.js:3:2500784)
at Array.map ()
at Function.\_module.service.Promise.map ([http://localhost:5601/bundles/commons.bundle.js:3:2500741](http://localhost:5601/bundles/commons.bundle.js:3:2500741))
at callResponseHandlers ([http://localhost:5601/bundles/commons.bundle.js:3:4895925](http://localhost:5601/bundles/commons.bundle.js:3:4895925))
at [http://localhost:5601/bundles/commons.bundle.js:3:4878286](http://localhost:5601/bundles/commons.bundle.js:3:4878286)
at processQueue ([http://localhost:5601/built\_assets/dlls/vendors.bundle.dll.js:435:204190](http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:435:204190))
at [http://localhost:5601/built\_assets/dlls/vendors.bundle.dll.js:435:205154](http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:435:205154)
at Scope.$digest ([http://localhost:5601/built\_assets/dlls/vendors.bundle.dll.js:435:215159](http://localhost:5601/built_assets/dlls/vendors.bundle.dll.js:435:215159))
I matched the all the possible formats for my date field. But I don't know the error.
My date field data -- \> 2020-01-30 06:00:00
My format ---\> "format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZ||yyyy-MM-dd'T'HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZZ"
Please help to solve this issue.
Regards,
Sangeetha Sivaji
---
### Author:  [@Vadims\_Daleckis](https://discuss.elastic.co/u/Vadims_Daleckis)
#### Post date: [February 7, 2020, 1:07pm UTC](https://discuss.elastic.co/t/date-field-issue-in-kibana-filtering/218276/2 "2020-02-07T13:07:45Z")
Seems that those error messages are coming from ElasticSearch:
- [https://github.com/elastic/elasticsearch/blob/bf317e8c4eb301f5ea9ff17a3d9595ae177cfbaf/server/src/main/java/org/elasticsearch/common/time/JavaDateFormatter.java#L169](https://github.com/elastic/elasticsearch/blob/bf317e8c4eb301f5ea9ff17a3d9595ae177cfbaf/server/src/main/java/org/elasticsearch/common/time/JavaDateFormatter.java#L169)
- [https://github.com/elastic/elasticsearch/search?q=Failed+to+parse+with+all+enclosed+parsers&unscoped\_q=Failed+to+parse+with+all+enclosed+parsers](https://github.com/elastic/elasticsearch/search?q=Failed+to+parse+with+all+enclosed+parsers&unscoped_q=Failed+to+parse+with+all+enclosed+parsers)
---
### Author:  [@Vadims\_Daleckis](https://discuss.elastic.co/u/Vadims_Daleckis)
#### Post date: [February 7, 2020, 1:10pm UTC](https://discuss.elastic.co/t/date-field-issue-in-kibana-filtering/218276/3 "2020-02-07T13:10:02Z")
Can you please give more description of what you are doing in Kibana, possibly add screenshot? Which version of Kibana are you using?
---
### Author:  [@Sangeetha\_Sivaji](https://discuss.elastic.co/u/Sangeetha_Sivaji)
#### Post date: [February 10, 2020, 9:46am UTC](https://discuss.elastic.co/t/date-field-issue-in-kibana-filtering/218276/4 "2020-02-10T09:46:15Z")
Hi Vadims\_Daleckis,
I am using kibana 7.3.1.
Yes, Error messages coming elasticsearch. I pushing the data to elasticsearch through api using dev tools in kibana. And I am creating the mappings in same dev tools.
As mentioned above, I will add images of my kibana.
while I'm trying to filter the date field those error messages are coming.
I tried to put all possible formats to match my date.
Though, same kind of error is coming.
I checked my mappings but I couldn't find any logical issues.
Please help me out.
Regards,
Sangeetha Sivaji
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 9, 2020, 9:46am UTC](https://discuss.elastic.co/t/date-field-issue-in-kibana-filtering/218276/5 "2020-03-09T09:46:20Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.