Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date appearing in different format in QVD

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.

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Load the date field with

date(name, 'MM-DD-YYYY')

in your script. QV converts the date as a numeric number.

vicky

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Hi,

Load the date field with

date(name, 'MM-DD-YYYY')

in your script. QV converts the date as a numeric number.

vicky

Not applicable
Author

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