Marco Russian

Yes I agree. I can not understand how this is such a difficult thing to implement.

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.

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.