I have a field correctly mapped as a datetime.
For example, a possible value could be
August 21st 2018, 20:00:00.000
Now I would like to filter documents in Kibana by selecting a particular date/time or an interval using the "add a filter" feature. However, I'm having throuble understanding which are the accepted formats.
I found the documentation here being unclear: https://www.elastic.co/guide/en/elasticsearch/reference/6.3/common-options.html#date-math
For example, I can input "now" as a filter, but the date formatted as "2018-08-21 20:00:00" or "2018.08.21 20:00:00" does not work.
I also tried using Unix timestamp (e.g. "1534874400") but I don't think the number is interpreted by Kibana as I would expect.
Could someone provide some examples?
Edit: "2018-08-21T18:00:00.000Z" seems to be working