Problems in visualization/filtering a date field in Discover module

Elastic Stack Kibana
1

Hi,
I am having a problem with date fields in the "Discover" module

Specifically I have a field with the following definition:
"checkIn": {
"type": "date"
}

Additionally I have the following settings:
. Timezone for date formatting "-> Browser ((GMT-3)
. Format of checkIn fields set to "DD-MM-YYYY"

The problem is that I have a great discrepancy in the display / filtering of that field. Specifically:

In Table -> checkIn = 03-09-2020
In Json -> checkIn = 2020-03-10
In filter (in order to match the document)-> checkIn = 2020-03-09

Can you see the problem?
How can I solve it?

Thanks in advance,
Pablo

Kibana version:
7.4

2

One more info ... the query that composes for ElasticSearch has the following form:
{
"checkIn": {
"gte": "2020-03-09",
"lte": "2020-03-09",
"time_zone": "America/Buenos_Aires"
}
}

3

If I understand your question, you've set the "date format" for the checkIn field to "DD-MM-YYYY", but you aren't seeing this format used consistently within Kibana? Would you mind providing screen-shots of the specific instances where you're seeing this date format ignored?

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.