# Date format set in advanced settings not replicated in CSV export from Discover

**URL:** <https://discuss.elastic.co/t/date-format-set-in-advanced-settings-not-replicated-in-csv-export-from-discover/300251>\
**Category:** Kibana\
**Created:** [March 21, 2022, 9:00pm UTC](https://discuss.elastic.co/t/date-format-set-in-advanced-settings-not-replicated-in-csv-export-from-discover/300251 "2022-03-21T21:00:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JulieB](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/julieb/32/103322_2.png) [@JulieB](https://discuss.elastic.co/u/JulieB)\
**Post date:** [March 21, 2022, 9:00pm UTC](https://discuss.elastic.co/t/date-format-set-in-advanced-settings-not-replicated-in-csv-export-from-discover/300251/1 "2022-03-21T21:00:46Z")

</div>

Version: Kibana 6.8.23

I set up a customized date format in Management \> Advanced Settings of my Kibana UI to `YYYY-MM-DD-THH:mm:ss` which works well when I look at the data in Discover tab or Dashboard view. However, once I save a search, and use the Share \> CSV Reports \> Generate CSV, the output CSV file shows the data in the former "default" date format `MMMM Do YYYY, HH:mm:ss.SSS` that I originally replaced.

Advanced Settings setup:

 ![Screen Shot 2022-03-21 at 1.53.07 PM](https://us1.discourse-cdn.com/elastic/original/3X/d/7/d7430aa3c11a962d2899cdbaba6d0ea4771bf5d8.jpeg)

Date format in Discover Tab showing the correct date format:  
 ![Screen Shot 2022-03-21 at 1.55.17 PM](https://us1.discourse-cdn.com/elastic/original/3X/7/d/7ddea26bd263641c47f2e1729528ea537d241235.png)

Date format in exported CSV file showing the former default date format instead of the new one set up in Advanced Settings:  
 ![Screen Shot 2022-03-21 at 1.53.58 PM](https://us1.discourse-cdn.com/elastic/original/3X/8/3/832fbe3f0c9e1d63f5fd56b81983673b29fa982f.png)

PS: I know that the actual time does not matched since the CSV is in UTC and that's not my problem here. My issue is the date format not being properly replicated in my CSV exports.

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [March 24, 2022, 9:45pm UTC](https://discuss.elastic.co/t/date-format-set-in-advanced-settings-not-replicated-in-csv-export-from-discover/300251/2 "2022-03-24T21:45:13Z")

</div>

Unfortunately, there is no formatting of csv in 6.x. I am trying to find the pr where we made this possible in 7,x version of the stack. will keep you posted.

Thanks,  
bhavya

---

<div class="post-metadata">

**Author:** ![JulieB](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/julieb/32/103322_2.png) [@JulieB](https://discuss.elastic.co/u/JulieB)\
**Post date:** [April 8, 2022, 11:27pm UTC](https://discuss.elastic.co/t/date-format-set-in-advanced-settings-not-replicated-in-csv-export-from-discover/300251/3 "2022-04-08T23:27:04Z")

</div>

Hi, thanks for helping me. Were you able to find out if that will be available in v.7?

---

<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 6, 2022, 11:27pm UTC](https://discuss.elastic.co/t/date-format-set-in-advanced-settings-not-replicated-in-csv-export-from-discover/300251/4 "2022-05-06T23:27:30Z")

</div>

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