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.
Please sign in to leave a comment.