topic Re: Dates saved to CSV as Text displayed as Date in QlikView

Dates saved to CSV as Text displayed as Date

dana — Thu, 23 May 2024 17:52:56 GMT

Hi People,

I have issue with dates which do not have the same format.

I loaded them as Text, and after exporting them to a CSV file, they still maintain their original format:

Dates in CSV

Exporting to Excel does not have that issue.

Dates in Excel

BTW, If I open the CSV file in Office 365, there is no issue.

Any idea how to resolve it?

Thanks!

Re: Dates saved to CSV as Text displayed as Date

marksouzacosta — Fri, 24 May 2024 04:18:32 GMT

Hi @dana,

Note sure if I understand the problem. CSV's don't have a type associated to its columns, they are always considered text. So, if you open your CSV using Notepad you should see the same format specified in your load script - if you have created the CSV using Qlik.

Now, when you open a CSV in Excel, you are subject to Excel's interpretation of the values. You can try to tell Excel which type, and format are the columns or maybe even some other advanced stuff like creating an Excel file and use a CSV file as a Data Source to populate the Excel file and them dealing with the date format using other Excel ways.

Re: Dates saved to CSV as Text displayed as Date

dana — Fri, 24 May 2024 04:32:48 GMT

Hi @marksouzacosta,

In Notepad as well as in Excel, indeed, there is no issue.

The question is why when opening the CSV file created by QlikView, a text is displayed both in General or in Date format.

How come the original format is somehow kept after converting the date into text:

Text(date) AS Date -Text.

Thanks!

Re: Dates saved to CSV as Text displayed as Date

dana — Wed, 29 May 2024 14:44:38 GMT

The solution was finding an Excel version that opens the CSV without any issue...