topic Re: Date format changes while storing into CSV in QlikView

Date format changes while storing into CSV

anil2185 — Mon, 07 Sep 2015 06:43:59 GMT

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

Re: Date format changes while storing into CSV

sunny_talwar — Mon, 07 Sep 2015 06:47:17 GMT

Are you using expression default formatting (Num(Expression, 'SomeFormat') or formatting it some way on the Number's tab? I think if you are using the first option, you might want to switch to the later option.

Re: Date format changes while storing into CSV

anil2185 — Mon, 07 Sep 2015 07:12:03 GMT

I am not showing any thing at sheet, I just load a table in QV, does some process and Saved it in CSV format.

While CSV conversion QV changes the date format into system date format.

That I don't want.

Re: Date format changes while storing into CSV

jyothish8807 — Mon, 07 Sep 2015 07:17:41 GMT

Hi Anil,

You might need to change the default date format from csv file. Hope it works.

Regards

Re: Date format changes while storing into CSV

sunny_talwar — Mon, 07 Sep 2015 07:20:07 GMT

What is the script of the table you are saving as CSV?

Re: Date format changes while storing into CSV

qlikviewwizard — Mon, 07 Sep 2015 07:22:55 GMT

Hi Can you please attach the sample file with data.

Re: Date format changes while storing into CSV

anil2185 — Mon, 07 Sep 2015 07:33:54 GMT

Find the attached sample file.

After running the script open the CSV made by application and see the Date fields.

Re: Date format changes while storing into CSV

sasiparupudi1 — Mon, 07 Sep 2015 07:58:32 GMT

I think your problem is excel than qlikview. You can change the default date format for excel in your regional settings.. Hope this helps

Sasi

Re: Date format changes while storing into CSV

qlikviewwizard — Mon, 07 Sep 2015 08:07:22 GMT

Hi ,

Change the CSV file output path. Give some different name as well.

For me it is working fine.

Please check the screens.

Hope this will Helpful to you. Thank you.

Re: Date format changes while storing into CSV

MarcoWedel — Mon, 07 Sep 2015 21:46:18 GMT

open your csv file using notepad instead of excel to verify that your export has the expected format.

regards

Marco

Re: Date format changes while storing into CSV

qlikviewwizard — Mon, 07 Sep 2015 23:37:37 GMT

‌hi anil,

did you able to manage to resolve your issue?

thank you.

Re: Date format changes while storing into CSV

anil2185 — Tue, 08 Sep 2015 05:00:27 GMT

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