Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Date appearing in different format in QVD

Hi,

Load the date field with

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

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

vicky

3 Replies

Date appearing in different format in QVD

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

Not applicable

Date appearing in different format in QVD

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

Date appearing in different format in QVD

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

Community Browser