DateTime format not exporting correctlly

ashmitp869 — Tue, 16 May 2023 04:45:38 GMT

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

Re: DateTime format not exporting correctlly

Rohan — Tue, 16 May 2023 05:40:15 GMT

Hi,

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

Thanks & Regards,

Rohan.