How to apply new time format of range in kibana's request query when visualizing data

Hi,
I have a question about changing time format in range query when visualizing data.

I have a date field 'time local' and its format is "dd/MMM/YYYY:HH:mm:ss Z"
ex.
"time_local": "15/Nov/2019:16:49:53 +0900",

The problem is that
kibana always use "strict_date_optional_time" time format in range query to search data and
with this time format my data is not appeared in visualization.

image

My es query with correct date format in range , elasticsearch gave a right answer.

Is it possible to change time format in range query in Kibana visualization request?

Thank you :slight_smile:

I think that you don't need to change the format in range query.

If you change the mapping setting in time_local from "dd/MMM/YYYY:HH:mm:ss Z" to "dd/MMM/yyyy:HH:mm:ss Z", you can find your expected result.

Here is my configurations and test results.

I hope this will help.

1 Like

OMG, it works!!
I really appreciate you!! :laughing::laughing: