qlikview date format issue while stroing as qvd

[qliklearnervir]

Hi,

I am loading a date from qvd and after modification saving it as another qvd where the issue with date arrived and date is not saving in modified format but saved it as default format where I read the format from original qvd.

Original load 

Table 1:

LOAD Date(Load_Date,'MM/DD/YYYY') as LOADDate 

from qvd;

Table2:

Load  LOADDate 

resident Table1;

store Table1 in //Folderlocation/Table2.qvd

but stored qvd is showing load_date as yyyy-mm-dd format but i want it as MM/DD/YYYY format.

[eliran]

Hi,

This sounds quite strange, maybe share the entire script of the relevant part?

Look at the following code.

Spoiler

SET DateFormat='D.M.YYYY';
SET TimestampFormat='D.M.YYYY h:mm:ss[.fff]';

Dates:
load Today() as date AutoGenerate(1);

store Dates into Dates.qvd;
drop Table Dates;
Dates2:
LOAD date(date,'DD/MM/YYYY') as LOADDate,date
FROM
[Dates.qvd]
(qvd);

BR,

Eliran,

[Brett_Bleess]

I would agree with @eliran, would have to believe it is the SET statement in your script regarding the date format that may be overriding things in your case on the load from the original QVD file etc...  The other option would be to do the data conversion again when loading the date before the new store...

Regards,
Brett