Discussion board where members can get started with QlikView.
I am importing SQL tables and then creating a QVDs, the date field shows properly when importing from SQL but When i import the QVDs in a QVW then the date field shows just a mere numbers.
I have attached all the relevent screenshot
Appreciate all your support.
Go to Solution.
Load the date field with
in your script. QV converts the date as a numeric number.
Date(C) as C;
Sql Select A,B,C from abc;
Store Data into .\data.qvd;
if you load data from excel file, set format of this column in table to 'Date' (not 'General' or any other format).
Hope this helps...