Hey, I have a problem concerning querying the dates in kibana. The raw data is in the following format: 2018-03-16 00:00:00 The dates are formatted in the mapping as follows: "starts": { "type": "date", "format": "yyyy-MM-dd 00:00:00" } Which is accepted by el…

For me, in Discover, this works; @timestamp:2015-09-22 (shows just that day's data) @timestamp:2015-09-22T23 (shows just that hour's data) But an unquoted date/time string containing : doesn't work. But quoted it does; @timestamp:"2015-09-22T23:50:13.253" returns just the one doc with that time…

Can't query for date or date range

Elastic Stack Kibana

bhavyarm (Bhavya R M) June 4, 2018, 9:04pm 2

Hi Erik,

Can you try searching for your timestamp like this: 2018-05-28T01:02:03.456 without the quotes around it.

We do have an existing issue on having better documentation for it.

Thanks,
Bhavya

Model data points with multiple timestamps

Topic		Replies	Views
Discover not filtering for date properly Elastic Search elastic-workplace-search	7	297	March 19, 2024
How to use Date Range filter in Kibana? Kibana	4	33552	September 10, 2019
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	826	March 13, 2019
Filtering based on @timestamp in Discover Kibana	4	9669	August 21, 2018
Date Range filter in data table Kibana 5.4.1 Kibana	6	1901	August 29, 2017

Can't query for date or date range

Related Topics