CODEWITHSUNDEEP
datetimeelasticsearchkibana
GreenRibbon
GreenRibbon

Reputation: 309

Datetimes in Kibana Off By One Month

I have two dates in my _type in Kibana. When I find my documents in the Discover tool, the date shown is one month earlier than it should be. Here, I should see February in the Table view: enter image description here

When I switch to the JSON view, I it looks like my date is correct:

enter image description here

Kibana is using the incorrect January date in all visualizations as well.

Here is the mapping I'm using for my dates:

    { "type": "date", "format": "YYYY-MM-DD HH:mm:ss" },

What have I done wrong?

Upvotes: 0

Views: 238

Answers (1)

Alcanzar
Alcanzar

Reputation: 17155

Your format on your date/time is wrong.

You are using YYYY-MM-DD instead of yyyy-MM-dd.

Specifically it's having issues because DD means "day of year", so it's always in January.

Upvotes: 1

Related Questions