Dates exported to Excel are not a date format
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.
-
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!
-
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.
-
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.
-
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.
-
same issue here - why can't this be seen as date automatically?
-
Yes I agree. I can not understand how this is such a difficult thing to implement.
Please sign in to leave a comment.
6 Comments