topic Date Format is changed while loading from QVD in QlikView

Date Format is changed while loading from QVD

Fri, 10 Feb 2012 15:31:52 GMT

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 — Fri, 10 Feb 2012 15:49:37 GMT

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

Fri, 10 Feb 2012 15:59:47 GMT

How can I do the second one.

I already have the format setting on top of my query

Jason_Michaelides — Fri, 10 Feb 2012 16:01:46 GMT

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 .....;

Fri, 10 Feb 2012 16:08:49 GMT

You are the best! quick answer..

Thank you so much

Jason_Michaelides — Fri, 10 Feb 2012 16:16:29 GMT

No problem.