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.
LOAD Date(Load_Date,'MM/DD/YYYY') as LOADDate
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.
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...
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.