CSV export date not applying correct date format (from a saved search in a dashboard)

[daohodac]

Kibana version:
7.5.1
Elasticsearch version:
7.5.1
Server OS version:
debian 9
Browser version:
chrome
Browser OS version:
78.0.3904.108
Original install method (e.g. download page, yum, from source, etc.):
.deb
Describe the bug:
Try to export a saved search from a dashboard as CSV. The CSV is correct but the format of the @timestamp is not OK for my customer because excel does not accept 2020-01-21T07:52:51.000Z which is the format I get (ISO8601).

I tried to change the format in the General Settings / Date format without effect.

The @timestamp should apply the Date format or there should be a way to specify the export format

Steps to reproduce:

1. create a saved search
2. add it to a dashboard
3. click on the top right gears (see snapshot herabove)
4. select download CSV
5. look at the @timestamp column (first one). The date is in the format 2020-01-21T07:52:51.000Z
6. go to Management / advanced settings / Date format and set YYYY-MM-DD HH:mm
7. back to the dashboard, download the CSV. The @timestamp is still in ISO8601 format

Expected behavior:
The @timestamp should be in the YYYY-MM-DD HH:mm format in the exported CSV

Screenshots (if relevant):

Errors in browser console (if relevant):

Provide logs and/or server output (if relevant):

Any additional context:

[omarsar]

I can also confirm this behavior. The export works well when done in the context of "Discover" but fails to apply the new format when done in the context of a "Dashboard". It's unexpected behavior. Hopefully, this is an easy fix. Thanks for posting @daohodac.

[elasticmachine]

Pinging @elastic/kibana-reporting-services (Team:Reporting Services)

[tsullivan]

Thanks for filing this. It looks like a valid bug.

[tsullivan]

This can be fixed for the "date" type of fields, but it looks like fixing "date_nanos" will require similar work as #30264

[tsullivan]

Fixed in #67027

Fixes Download CSV showing raw data instead of formatted per the index pattern

[tsullivan]

Closed in #67027