Export datetime fields to excel with format WWW h:mm shows fixed WWW in excel

[PedroC]

Hi everyone,

I'm having an issue exporting a regular table with datetime fields that are defined using format WWW h:mm.

This shows the abbreviation of the weekdays and the hour and minute of an event.

This is shown correctly in Qlik Sense as you can see (sorry, it's spanish so L is monday, M is tuesday and so on):

The issue occurs when the user tries to export this data to excel with format. This is what you get:

It seems that excel does not understand the format WWW so it shows "WWW" as a literal.

The data is correctly exported as datetime and if you go into numeric format in excel you can change the correct format that seems to be "ddd" instead of "WWW":

And now datetime shows correctly:

Does anybody know a workaround for this issue?

Thanks in advance!