Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarkharpude
Creator III
Creator III

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

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

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!!!!

View solution in original post

4 Replies
swuehl
MVP
MVP

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
PrashantSangle

Hi,

Use combination of date#() and alt()

for alt() see in help menu

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable

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!!!!