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

[sunny_talwar]

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.

[anil2185]

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.

[jyothish8807]

Hi Anil,

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

Regards

KC

[sunny_talwar]

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

[qlikviewwizard]

Hi Can you please attach the sample file with data.

[anil2185]

Find the attached sample file.

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

[sasiparupudi1]

Hi

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

[qlikviewwizard]

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.

[MarcoWedel]

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

regards

Marco