Dates exported to Excel are not a date format

Posted Sep 03, 2020

When you export a query to Excel the date values do not come across as a date format. In my query, I have created a calculated attributed with the following formula

DATE_FORMAT([Ticket created - Date], "dd/mm/yyyy")

However, when it comes across to Excel even after setting the format to Date and you go to filter on that column excel sees it as general text. You have to edit each cell for it to be converted to a date value.

7 comments

Date

Mitzi Broom

Sep 07, 2020

Hi Marco

I would say probably best not to create the field as a calculated attribute, but simply include the field as it is. In one of my queries, I have the Ticket Created - Date field in our timesheet reports and although within the query today appears as 2020-09-07, when the report is scheduled and sent to the support team members in CSV format, the dates appear in the native format and are filterable as Excel dates.

Good luck!

Marco Russian

Sep 08, 2020

Hi Mitzi

Thanks for your reply, I just tried downloading the csv formatted query, however, it is separated by ; and when opening in excel it still detects commas within quotes, so this is not a viable option for me.

Valerie Conlon

Jun 08, 2021

Any news on this issue? Seems pretty crazy that dates aren't exporting as dates. I am not using a calculated attribute, just the created date and solved date fields.

Allison Ramsey-Henry

Jun 30, 2021

Agreed. The loss of format in Excel reports appears to make it impossible for us to schedule dashboards directly to internal and external stakeholders. Right now it looks like my only option is to download every report that needs to go out, fix the formatting, and then send it to the recipient myself. This is a huge drag time-wise and seems like a big miss considering the scheduled dashboard option.