Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
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