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

[Anonymous]

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..

[Anonymous]

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]

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...