Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.