Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Format issues when exporting to data to Excel

Hi

I have an application where I have functionality to export my objects and data to Excel using a button. I am trying to export a table with Calendar dates and when I export them the date format is wrong. I am after the date format 'DD/MM/YYYY' but whenever I export data the format is DD/MMYYYY in some cases and then MM/DD/YYYY, exporting extra lines from what I wish to export.

Will I need to something in my macro so that whenever I export data the format is the correct date format?

Is this a user Excel issue?

Any ideas.

Thanks

1 Reply
Anonymous
Not applicable
Author

Hi rajesh

Please can you attach to see what is the problem?

Regards