# Date problem

**URL:** <https://discuss.elastic.co/t/date-problem/187860>\
**Category:** Kibana\
**Created:** [June 27, 2019, 2:05pm UTC](https://discuss.elastic.co/t/date-problem/187860 "2019-06-27T14:05:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![soufiane1](https://avatars.discourse-cdn.com/v4/letter/s/dfb087/32.png) [@soufiane1](https://discuss.elastic.co/u/soufiane1)\
**Post date:** [June 27, 2019, 2:05pm UTC](https://discuss.elastic.co/t/date-problem/187860/1 "2019-06-27T14:05:02Z")

</div>

Hi everyone,

I am trying to load a csv file which contains a date field but kibana display 1970 for every year, here is an example :

 ![erreur](https://us1.discourse-cdn.com/elastic/original/3X/1/7/1716b6efe153040a1448683d1697046c82388051.png)

and here is how kibana display it :

![erreur2](https://us1.discourse-cdn.com/elastic/original/3X/2/e/2e1f79b4ce1e58af1b0609123801f9a9dd2e32f4.png)

Can anyone help pls

---

<div class="post-metadata">

**Author:** ![raya](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raya/32/55497_2.png) [@raya](https://discuss.elastic.co/u/raya)\
**Post date:** [July 5, 2019, 12:36pm UTC](https://discuss.elastic.co/t/date-problem/187860/2 "2019-07-05T12:36:23Z")

</div>

Hi there  
Have you tried changing the Time Format when importing your csv to match the format used in your file?

 ![screencapture-edit-date-time-field](https://us1.discourse-cdn.com/elastic/original/3X/1/2/1204782edc6619751cb8eef738dd759f11ebe2ae.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 2, 2019, 12:36pm UTC](https://discuss.elastic.co/t/date-problem/187860/3 "2019-08-02T12:36:24Z")

</div>

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