Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date fields when sent to Excel are not correctly formatted

Hi !

I have this small QVW where a Date field (DATE_TEST) is shown on several objects.

For any of those objects, when I export them to Excel, I have the Date not correctly formatted in Excel. I have to fix the formatting manually in Excel. Then I can see the correct date.

Have I made something wrong or is this a bug ?

Thanks !

1 Solution

Accepted Solutions
Not applicable
Author

Hi

If you set the format for the field under Document properties (Ctrl+Alt+D), the tab "Number" and select Date for the DATE_TEST-field it should work.

/Fredrik

View solution in original post

1 Reply
Not applicable
Author

Hi

If you set the format for the field under Document properties (Ctrl+Alt+D), the tab "Number" and select Date for the DATE_TEST-field it should work.

/Fredrik