Date Format is changed while loading from QVD

[#1]

Hi guys,

I am loading a date field from a table to QVD and the format there is MM/DD/YYYY.

Then when I load it from the QVD to QVW the format is gone and all what I see is number such as:  40728 !

Anybody has a solution?

Thxs,

[Jason_Michaelides]

Don't forget a date is really just an integer underneath any formatting.  Unless you tell QV to format it, it will just return the number.

Ensure you have these (or similar) settings at the top of your load script:

SET TimeFormat='hh:mm:ss';

SET DateFormat='MM/DD/YYYY';

SET TimestampFormat='MM/DD/YYYY hh:mm:ss[.fff]';

Or else format it explicitly while loading with

Date(DateField,'MM/DD/YYYY')     AS     DateField

Hope this helps,

Jason

[#3]

How can I do the second one.

I already have the format setting on top of my query

[Jason_Michaelides · Accepted solution]

I assume your load script looks something like this:

Data:

LOAD

     Field1,

     Field2,

     Field3,

     DateField,

..

..

FROM .....;

Change this to:

Data:

LOAD

     Field1,

     Field2,

     Field3,

     Date(DateField,'MM/DD/YYYY')     AS     DateField

..

..

FROM .....;

[#5]

You are the best! quick answer..

Thank you so much

[Jason_Michaelides]

No problem.