DateTime format not exporting correctlly

[ashmitp869]

Hi All,

I used Date([SE Start Dttm],'DD/MM/YYYY hh:mm:ss') as [SE Start DateTime]  to get the format in qlikview script.

But when exporting the data to excel it giving me funny format 

its working when change the date format. Is there is any to fix the format when doing the export.

Thanjs

[Rohan]

Hi,

Try : Text(Date([SE Start Dttm],'DD/MM/YYYY hh:mm:ss')) as your Dimension expression.

Thanks & Regards,

Rohan.