Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
JustQlikS
Contributor
Contributor

Qlik Sense Date Format

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,

Labels (3)
1 Solution

Accepted Solutions
JordyWegman
Partner
Partner

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

Work smarter, not harder

View solution in original post

1 Reply
JordyWegman
Partner
Partner

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

Work smarter, not harder

View solution in original post