# Kibana cannot read timestamp from ES

**URL:** <https://discuss.elastic.co/t/kibana-cannot-read-timestamp-from-es/42423>\
**Category:** Kibana\
**Created:** [February 22, 2016, 7:06pm UTC](https://discuss.elastic.co/t/kibana-cannot-read-timestamp-from-es/42423 "2016-02-22T19:06:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![anhlqn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anhlqn/32/5454_2.png) [@anhlqn](https://discuss.elastic.co/u/anhlqn)\
**Post date:** [February 22, 2016, 7:06pm UTC](https://discuss.elastic.co/t/kibana-cannot-read-timestamp-from-es/42423/1 "2016-02-22T19:06:23Z")

</div>

Hi All,

I have an IIS log index with the following timestamp

GET iis\_log-2016.7/\_search

```auto
[...]
"_source": {
          "timestamp": "2016-02-18T00:20:49.3895597Z",
[...]

```

GET iis\_log-2016.7/\_mapping/field/timestamp

```auto
      "mapping": {
        "timestamp": {
          "type": "date",
          "format": "epoch_millis||dateOptionalTime"
        }
      }

```

When I tried adding this index to Kibana 4.2, Kibana could not recognize any time-field name. After upgraded to ES 2.2.0 and Kibana 4.4.0, Kibana is now able to see the timestamp field as a time-field name and successfully add the index pattern. However, on Discover app, no matter how big the time frame is, Kibana does not show any logs. The IIS log index contains data from a week ago, and I can see data by executing /\_search on the index.

My guess is that the milisecond/microsecond `.3895597Z` has 7 digits instead of 3 or 6 which prevents Kibana from reading the timestamp even though the field is formatted in ES.

I'm looking into fixing from the log source, but any help on fixing it on either ES or Kibana is appreciated.

Thanks,

---

<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, 2:01pm UTC](https://discuss.elastic.co/t/kibana-cannot-read-timestamp-from-es/42423/2 "2017-07-06T14:01:24Z")

</div>