# Kibana is not identifying the ElasticSearch index date type

**URL:** <https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411>\
**Category:** Kibana\
**Created:** [September 5, 2018, 1:10pm UTC](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411 "2018-09-05T13:10:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Diogo\_Azevedo\_Gouvei](https://avatars.discourse-cdn.com/v4/letter/d/65b543/32.png) [@Diogo\_Azevedo\_Gouvei](https://discuss.elastic.co/u/Diogo_Azevedo_Gouvei)\
**Post date:** [September 5, 2018, 1:10pm UTC](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411/1 "2018-09-05T13:10:08Z")

</div>

I use Elastic 6.3.2 with Kibana 6.3.2 and am having problems with date type field indexes, since they are not identified as date type fields by Kibana, even though they are indexed as date in Elastic.  
The date fields are: created\_at and updated\_at.  
I need some help, please.

 ![index%20date%20%20in%20jason%20kibana](https://us1.discourse-cdn.com/elastic/original/3X/e/a/ea8378ded52a5e16a08bb83908d49f3a92e5991e.png)  
 ![Not%20field%20date](https://us1.discourse-cdn.com/elastic/original/3X/7/f/7f93ec4e3a1917f647cc6ac2f32c0cf3c6575700.png)  
 ![created_at](https://us1.discourse-cdn.com/elastic/original/3X/5/b/5b693b88cedd2f392d687c61cf9adf2dbb438ccf.png)  
 ![update_at](https://us1.discourse-cdn.com/elastic/original/3X/0/3/030372724ea81001032faa405c7fbb4a455b522e.png)

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [September 5, 2018, 1:49pm UTC](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411/2 "2018-09-05T13:49:46Z")

</div>

Your index mapping is incorrect. The date field is stored as text. Instead, it needs to be stored as a [date](https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html).

---

<div class="post-metadata">

**Author:** ![Diogo\_Azevedo\_Gouvei](https://avatars.discourse-cdn.com/v4/letter/d/65b543/32.png) [@Diogo\_Azevedo\_Gouvei](https://discuss.elastic.co/u/Diogo_Azevedo_Gouvei)\
**Post date:** [September 5, 2018, 2:10pm UTC](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411/3 "2018-09-05T14:10:24Z")

</div>

With index in date type, the same error occurs.

 ![created_at_type_date](https://us1.discourse-cdn.com/elastic/original/3X/6/4/64d23eb9f318ea0989a8594fe6947d608b99b353.png)  
 ![updated_at_type_date](https://us1.discourse-cdn.com/elastic/original/3X/e/d/ed4fb02ddcca6e7ba0f389a687c1df8f04f53b9b.png)  
 ![Mapping%20in%20kibana](https://us1.discourse-cdn.com/elastic/original/3X/d/9/d9b69a3bf2dc00e96e238a5513741d9cecdee58a.png)  
 ![fields%20in%20Kibana](https://us1.discourse-cdn.com/elastic/original/3X/4/5/455c4cb075af1e3dce6e15509417dccbf342a141.png)  
 ![field%20not%20in%20kibana](https://us1.discourse-cdn.com/elastic/original/3X/e/5/e5cce29df30467f0c6a6a943f185e980d2d4c2cb.png)

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [September 5, 2018, 2:31pm UTC](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411/4 "2018-09-05T14:31:38Z")

</div>

Kibana index patterns do not auto refresh when the underlying elasticsearch index mappings change. You will need to manually refresh the index pattern so the new mappings are used.

Under Management -\> index patterns, open your index pattern and click the "refresh field list" button

---

<div class="post-metadata">

**Author:** ![Diogo\_Azevedo\_Gouvei](https://avatars.discourse-cdn.com/v4/letter/d/65b543/32.png) [@Diogo\_Azevedo\_Gouvei](https://discuss.elastic.co/u/Diogo_Azevedo_Gouvei)\
**Post date:** [September 5, 2018, 2:58pm UTC](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411/5 "2018-09-05T14:58:32Z")

</div>

Thanks, is work.

---

<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:** [October 3, 2018, 2:58pm UTC](https://discuss.elastic.co/t/kibana-is-not-identifying-the-elasticsearch-index-date-type/147411/6 "2018-10-03T14:58:32Z")

</div>

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