topic Re: qlikview date format issue while stroing as qvd in QlikView

qlikview date format issue while stroing as qvd

qliklearnervir — Wed, 26 Aug 2020 19:18:35 GMT

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.

Re: qlikview date format issue while stroing as qvd

eliran — Wed, 26 Aug 2020 19:59:25 GMT

Hi,

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

Look at the following code.

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,

Re: qlikview date format issue while stroing as qvd

Brett_Bleess — Tue, 08 Sep 2020 19:25:33 GMT

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