Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

qlikview date format issue while stroing as qvd

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.

 

 

 

2 Replies
Highlighted
Creator III
Creator III

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,

 

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.