Date format changed in Qlikview when we saved some records in CSV

[sagarkharpude]

Hi,

I have saved some records in CSV. But after saving the csv file date format get changed in Qlikview. Here is the screenshot for the same.

Date in white are new records which are entered into csv file. And cell in gray are old records which are already exist before. I want the date format as cells appearing in Gray color(Excluded values).

Thanks

[swuehl]

Not sure how you have read the old and new records in, so some more context would be helpful (script, sample files etc.)

In general, have a look at

Get the Dates Right

To read in multiple formats, you can use the Alt() function.

[Anil_Babu_Samineni]

Show the CSV Records on one images

OR

Date(FieldName) as FieldName

[PrashantSangle]

Hi,

Use combination of date#() and alt()

for alt() see in help menu

Regards,

[Anonymous · Accepted solution]

Hi Sagar, that is because QlikView understand that is text, not date.

Use Date# or timestamp# on load:

TimeStamp(TimeStamp#([Response Date],'MM/DD/YYYY hh:mm'),'MM/DD/YYYY hh:mm') as [Response Date]

Regards!!!!