issue with datetime format when exporting to excel

ashmitp869 — Thu, 13 Jul 2023 00:55:27 GMT

Hi there,

Initially I have made datetime format in SQL , but that is giving me datetime field as text.

.Though when export to excel was giving correct datetime format.

Then I changed the datetime in Qlikview script like below:

Date([SE End Dttm],'DD/MM/YYYY h:mm:ss[.fff] TT') as [SE End DateTime]

Which is giving is correct result i.e all datetime field is date instead of text.

But now when I export to excel the datetime field is like below:

Please suggest, how should keep the date format intact when export to excel is done.

Re: issue with datetime format when exporting to excel

cristianj23a — Fri, 14 Jul 2023 03:13:40 GMT

Hello, you need to format it in the table or graph.

Go to properties and then to the numbers section, there you click on Date/time and add the format.

I send you the image.

Regarts.