Date format changes while storing into CSV

[anil2185]

Hi All,

I am storing a QV table into CSV format, which consists of some date fields and some text fields.

When I open the stored CSV file the date format is changed (mm-dd-yyyy).

I want the date format which I have made in QV table (yyyy-mm-dd).

Any idea to do the same.

Regards,

Anil

[qlikviewwizard]

‌hi anil,

did you able to manage to resolve your issue?

thank you.

[anil2185]

Not able to resolve issue, because I can't change the date format in regional settings of server.

I think instead of storing it into csv format I need to use macro to export the file at the time of reloading.

Please suggest what else I can do....

Thanks,

Anil