# How to update the default datatype of the field from text to date?

**URL:** <https://discuss.elastic.co/t/how-to-update-the-default-datatype-of-the-field-from-text-to-date/139604>\
**Category:** Elasticsearch\
**Created:** [July 11, 2018, 3:07pm UTC](https://discuss.elastic.co/t/how-to-update-the-default-datatype-of-the-field-from-text-to-date/139604 "2018-07-11T15:07:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vebabu](https://avatars.discourse-cdn.com/v4/letter/v/919ad9/32.png) [@vebabu](https://discuss.elastic.co/u/vebabu)\
**Post date:** [July 11, 2018, 3:07pm UTC](https://discuss.elastic.co/t/how-to-update-the-default-datatype-of-the-field-from-text-to-date/139604/1 "2018-07-11T15:07:30Z")

</div>

I am using AWS IoT CORE and transferring the data to Elastics search service. Then i am creating the Index pattern in the Kibana.  
My IoT device gives the date in standard UTC format "2018-07-01 01:01:01:44567" OR "YYYY-MM-DD HH:mm:ss:SSS"

field : "event\_ts7" by default is loaded as string. Can you please help me with updating the default data type to date from string ?? I Need the field to be date.

Elastic Search image :

 ![26%20AM](https://us1.discourse-cdn.com/elastic/original/3X/e/4/e4f7c93b72d82df88b3de2c7be4450ab6f9219dc.png)

Kibana Index pattern image :

 ![41%20AM](https://us1.discourse-cdn.com/elastic/original/3X/1/c/1cb4a0c9e468ad25bda1e86122c59d253c5a6390.png)  
 ![02%20AM](https://us1.discourse-cdn.com/elastic/original/3X/7/8/78fa3582e63afa97e28fa3c9e32a14bf40bd16dc.png)

Also I can see duplicate fields in the index patter with the .Keyword .  
How to remove the .keyword field.

 ![00%20AM](https://us1.discourse-cdn.com/elastic/original/3X/1/e/1ee9d0ce37ec371c623eabbd08130769bda3fbcb.png)

---

<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:** [August 8, 2018, 3:07pm UTC](https://discuss.elastic.co/t/how-to-update-the-default-datatype-of-the-field-from-text-to-date/139604/2 "2018-08-08T15:07:41Z")

</div>

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