# UTC date problem when Import csv with a date format such as 2014-10-14 00:00:00

**URL:** https://discuss.elastic.co/t/utc-date-problem-when-import-csv-with-a-date-format-such-as-2014-10-14-00-00-00/84094
**Category:** Elasticsearch
**Created:** [April 29, 2017, 5:38pm UTC](https://discuss.elastic.co/t/utc-date-problem-when-import-csv-with-a-date-format-such-as-2014-10-14-00-00-00/84094 "2017-04-29T17:38:26Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![shilong](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@shilong](https://discuss.elastic.co/u/shilong)
#### Post date: [April 29, 2017, 5:38pm UTC](https://discuss.elastic.co/t/utc-date-problem-when-import-csv-with-a-date-format-such-as-2014-10-14-00-00-00/84094/1 "2017-04-29T17:38:26Z")

</div>

UTC date problem when Import csv with a date format such as 2014-10-14 00:00:00,  
eventually the elastic search reads this date string to 2014-10-14 16:00:00, anyway to make it consistency?

Thank you!

---

<div class="post-metadata">

### Author: ![shilong](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@shilong](https://discuss.elastic.co/u/shilong)
#### Post date: [April 29, 2017, 6:19pm UTC](https://discuss.elastic.co/t/utc-date-problem-when-import-csv-with-a-date-format-such-as-2014-10-14-00-00-00/84094/2 "2017-04-29T18:19:35Z")

</div>

Problem solved! Just select UTC at Kibana advanced setting

---

<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: [May 27, 2017, 6:26pm UTC](https://discuss.elastic.co/t/utc-date-problem-when-import-csv-with-a-date-format-such-as-2014-10-14-00-00-00/84094/3 "2017-05-27T18:26:31Z")

</div>

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