Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Load the date field with
date(name, 'MM-DD-YYYY')
in your script. QV converts the date as a numeric number.
vicky
Hi,
Try this.
Data:
Load A,
B,
Date(C) as C;
Sql Select A,B,C from abc;
Store Data into .\data.qvd;
Regards,
Kaushik Solanki
Hi,
Load the date field with
date(name, 'MM-DD-YYYY')
in your script. QV converts the date as a numeric number.
vicky
Hi,
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...
Regards