convert string from text file to Date

[#1]

Hi,

I just want to ask how to convert a string to date format? Attached is the sample QlikView file and its source which is a text file.

Thanks!

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Use the following expression:

Date(Date#(Timestamp, 'DD-MMM-YY')) AS DateField

Hope that helps.

Miguel

[#3]

I already solved the problem, thanks for your reply sir, I also used that expression and the main problem is that there's a space after the date in our source file so I have to trim it..

Thank you again sir!