issue with datetime format when exporting to excel

[ashmitp869]

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.

[cristianj23a]

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.