Kibana search filter showing parser errors on date filter. Error:failed to create query: failed to parse date field [2021-02-04T00:00:00.000Z] with format [yyyyMMdd]: [failed to parse date field [2021-02-04T00:00:00.000Z] with format [yyyyMMdd]]

gbandasha · March 1, 2021, 8:51pm

I have set up my Index template in elastic and the transaction_date column is carrying the format as 'yyyyMMDD' but when I try to add the filter on that filter by click on the plus icon next to the column name it throws the below error.

failed to create query: failed to parse date field [2021-02-04T00:00:00.000Z] with format [yyyyMMdd]: [failed to parse date field [2021-02-04T00:00:00.000Z] with format [yyyyMMdd]]

afharo · March 3, 2021, 11:04am

Hi @gbandasha,

thank you for sharing the issue! It looks like a bug to me. I've created the issue Filters should apply the original date from `_source` instead of the formatted one · Issue #93401 · elastic/kibana · GitHub so our team can look at it and try to solve it.

Please, feel free to follow it for more updates on the progress and if any questions arise.

Topic		Replies	Views
Date Field Issue in kibana filtering Elasticsearch	4	1145	March 9, 2020
Kibana Dashboard showing parser errors on date filter. Error: "failed to parse date field [1542281539000] with format [yyyy-MM-dd'T'HH:mm:ss.SSSZ]" Kibana	3	898	March 13, 2019
Kibana : Discover: failed to parse date field [2018-08-13T14:44:21.253] with format Invalid date Kibana	2	3270	September 17, 2018
Failed to parse date field Kibana	4	2857	July 6, 2017
Canvas Time Filter - [parse_exception] failed to parse date field Kibana	1	749	December 31, 2019

Kibana search filter showing parser errors on date filter. Error:failed to create query: failed to parse date field [2021-02-04T00:00:00.000Z] with format [yyyyMMdd]: [failed to parse date field [2021-02-04T00:00:00.000Z] with format [yyyyMMdd]]

Related topics