Qlik Sense Date Format

[JustQlikS]

Hi There,

I'm relatively new to Qlik Sense and I am having an issue with a date format. When viewing it on the dashboard it displays as:

• 1/9/2020 6:36:56 PM

However when I export the data it appears as below:

• 09/01/2020 6:36:56 PM

What I also noted is that on the exported file it seems to cut off the seconds and PM/AM.

I just want it to simply export the same way it is displayed on the dashboard. Currently there is no expression but just a value pulled from the data that I would like to convert.

Thank you,

[JordyWegman · Accepted solution]

Hi,

This could be a setting that has something to do with your Excel setting (assuming you export this to Excel). Have you checked these settings?

Jordy

Climber