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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Change Qlikview Excel export Date format to dd/mm/yyy

Hi all,

My SQL database contains dates in dd/mm/yyyy... however, when i export to excel from a qlikview chart, the date format changes to American date format: mm/dd/yyyy


Does anyone know how to tell qlikview to export any dates to dd/mm/yyyy format?


any help would be appreciated!!


Thanks!!

Fab..

11 Replies
Anonymous
Not applicable
Author

Is :

Date(Date#(Date,'dd/mm/yyyy'),'dd/mm/yyyy') same as:

DATE("due_date",'DD/MM/YYYY') as ISHBPODueDate


Where "due_date" is the original database field...?


Fab

Anonymous
Not applicable
Author

Didn't realise I hadn't saved the QV app, I assumed saving the script (since it was a scripting change) and reloading would suffice, once I saved my QV document, the change was published to my QV access point and it now works...

thanks for your help everyone...

Cheers...