# Kibana not showing data due to timestamp issues

**URL:** <https://discuss.elastic.co/t/kibana-not-showing-data-due-to-timestamp-issues/64715>\
**Category:** Kibana\
**Created:** [November 2, 2016, 1:03pm UTC](https://discuss.elastic.co/t/kibana-not-showing-data-due-to-timestamp-issues/64715 "2016-11-02T13:03:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gilisade](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gilisade/32/98740_2.png) [@gilisade](https://discuss.elastic.co/u/gilisade)\
**Post date:** [November 2, 2016, 1:03pm UTC](https://discuss.elastic.co/t/kibana-not-showing-data-due-to-timestamp-issues/64715/1 "2016-11-02T13:03:13Z")

</div>

hi  
i'm having some issues in kibana  
i have a log file that it's date looks like this :  
02-11-2016 09:48:33 AM ...  
as you can see the time is a 12 hour day (AM\PM)  
i've parsed it with date filter in logstash  
after turnning it into one filed called date that looks like this : 02-11-2016 09:48:33 AM

```
date {
     match => ["date" , "dd-MM-YYYY hh:mm:ss aa"]
}

```

now the parsing seems to go well - and the index is created in ES (checked and got results)  
but when i get to kibana i get the "no results" screen no matter how far back i went - changed the time frame to 5 years ago and still no results  
BTW if i inserted the index to kibana and unchecked "index contains time-based events" - everything worked fine

but what was more interesting is when i parsed the date like this (changed hh to HH)

```
date {
     match => ["date" , "dd-MM-YYYY HH:mm:ss aa"]
}

```

suddenly i got results in kibana - but the date is wrong (when it comes to PM - becuse it does not change it to 24 hour clock like hh does)  
i checked the mapping and timestamp is correctly defined : type:date

i'm using logstash kibana and ES 5.0.0

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [November 2, 2016, 2:46pm UTC](https://discuss.elastic.co/t/kibana-not-showing-data-due-to-timestamp-issues/64715/2 "2016-11-02T14:46:12Z")

</div>

> [@gilisade](#):
>
> after turnning it into one filed called date that looks like this : 02-11-2016 09:48:33 AM

It looks like that where? If that's the date you see what you query Elasticsearch directly, then something isn't right. When you look at that field in Elasticsearch, with a search for example, you should see something more like `2016-10-21T16:54:19.629Z`. If you are seeing your format still, I suspect there might be something wrong with the mapping, which may also explain why Kibana can't find any data.

How are you checking the mapping on that index?

---

<div class="post-metadata">

**Author:** ![gilisade](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gilisade/32/98740_2.png) [@gilisade](https://discuss.elastic.co/u/gilisade)\
**Post date:** [November 3, 2016, 6:50am UTC](https://discuss.elastic.co/t/kibana-not-showing-data-due-to-timestamp-issues/64715/3 "2016-11-03T06:50:21Z")

</div>

I created the field in logstash .. What i see in ES IS EXACTLY What you wrote ..  
i dont know why but it's working now  
i haven't changed a thing

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 1:34pm UTC](https://discuss.elastic.co/t/kibana-not-showing-data-due-to-timestamp-issues/64715/4 "2017-07-06T13:34:48Z")

</div>