Dates exported to Excel are not a date format

2 Comentarios

  • Mitzi Broom

    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!

    0
  • Marco Russian

    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.

    0

Iniciar sesión para dejar un comentario.

Tecnología de Zendesk