# Malformed date field to populate into new field in elasticsearch

**URL:** <https://discuss.elastic.co/t/malformed-date-field-to-populate-into-new-field-in-elasticsearch/168155>\
**Category:** Elasticsearch\
**Created:** [February 13, 2019, 6:40am UTC](https://discuss.elastic.co/t/malformed-date-field-to-populate-into-new-field-in-elasticsearch/168155 "2019-02-13T06:40:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ram18](https://avatars.discourse-cdn.com/v4/letter/r/73ab20/32.png) [@Ram18](https://discuss.elastic.co/u/Ram18)\
**Post date:** [February 13, 2019, 6:40am UTC](https://discuss.elastic.co/t/malformed-date-field-to-populate-into-new-field-in-elasticsearch/168155/1 "2019-02-13T06:40:25Z")

</div>

I have created a index in elasticsearch with multiple date field and formatted the column as "yyyy-mm-dd HH:mm:ss". Eventually I found the date is malformed and was populating wrong data into the fields. The index has more than 6 lakh records and I don't want to leave any data. Now I need to create another field or new index with same date field and format as "YYYY-MM-ddTHH:mm:ss.Z" and populate all the records in to new index or new field. please let me know how can we achieve this

---

<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:** [March 13, 2019, 6:40am UTC](https://discuss.elastic.co/t/malformed-date-field-to-populate-into-new-field-in-elasticsearch/168155/2 "2019-03-13T06:40:27Z")

</div>

Closed on March 13, 2019, 6:40am UTC

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