# Kibana report export CSV file wrong date format

**URL:** <https://discuss.elastic.co/t/kibana-report-export-csv-file-wrong-date-format/209882>\
**Category:** Kibana\
**Created:** [November 28, 2019, 3:36pm UTC](https://discuss.elastic.co/t/kibana-report-export-csv-file-wrong-date-format/209882 "2019-11-28T15:36:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![OrlandoEscalante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/orlandoescalante/32/63998_2.png) [@OrlandoEscalante](https://discuss.elastic.co/u/OrlandoEscalante)\
**Post date:** [November 28, 2019, 3:36pm UTC](https://discuss.elastic.co/t/kibana-report-export-csv-file-wrong-date-format/209882/1 "2019-11-28T15:36:17Z")

</div>

Kibana/ES version 7.4.1

After a search in Kibana, the results are showed in the right format in Kibana, but after those results are exported as CSV file, they are showed all in the file as 1970-\*

This is a similar issue as reported on [CSV Report Export Times Incorrect](https://discuss.elastic.co/t/csv-report-export-times-incorrect/160226) ( but no solution/fix applied or at least explained. )

 ![Screenshot%20from%202019-11-28%2009-30-33](https://us1.discourse-cdn.com/elastic/original/3X/b/8/b844b2703bb30bd2a024faff989884c1f11f581c.png)

Same search exported as CSV file report:  
 ![Screenshot%20from%202019-11-28%2009-32-29](https://us1.discourse-cdn.com/elastic/original/3X/f/7/f7c57740f37b59a6671ec000e316d089a2945c2b.png)

It doesn't preserve the same date/time format on exported files.

---

<div class="post-metadata">

**Author:** ![matw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matw/32/13913_2.png) [@matw](https://discuss.elastic.co/u/matw)\
**Post date:** [November 28, 2019, 3:58pm UTC](https://discuss.elastic.co/t/kibana-report-export-csv-file-wrong-date-format/209882/2 "2019-11-28T15:58:17Z")

</div>

Hi  
Could you add a RAW sample data record as JSON here, The screens you've posted are a bit distorted, and it would be interesting how your timestamps are stored in ES  
Thanks a lot & best,  
Matthias

---

<div class="post-metadata">

**Author:** ![OrlandoEscalante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/orlandoescalante/32/63998_2.png) [@OrlandoEscalante](https://discuss.elastic.co/u/OrlandoEscalante)\
**Post date:** [November 28, 2019, 7:10pm UTC](https://discuss.elastic.co/t/kibana-report-export-csv-file-wrong-date-format/209882/3 "2019-11-28T19:10:54Z")

</div>

The report Json shows it in seconds:

```
"report_date": 1550495175

```

 ![Screenshot%20from%202019-11-28%2013-03-29](https://us1.discourse-cdn.com/elastic/original/3X/3/c/3c2a547593c914765e04ddeffa6eeb423bf1319d.png)

But the Kibana UI at the time to export it use a different convertion assuming milliseconds instead of seconds and shows as 1970-\*, as the following example on conversion assupmtions:

new Date(1550495175).toString()

"Sun Jan 18 1970 16:41:35 GMT-0600 (Central Standard Time)"

It looks like an issue more on the Kibana interface doing the assupmtions when it is in seconds/milliseconds with the stored value of the date.

---

<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:** [December 26, 2019, 7:11pm UTC](https://discuss.elastic.co/t/kibana-report-export-csv-file-wrong-date-format/209882/4 "2019-12-26T19:11:04Z")

</div>

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