topic convert string from text file to Date in QlikView https://community.qlik.com/t5/QlikView/convert-string-from-text-file-to-Date/m-p/310628#M114713 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>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.</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 27 Jan 2012 05:49:53 GMT 2012-01-27T05:49:53Z convert string from text file to Date https://community.qlik.com/t5/QlikView/convert-string-from-text-file-to-Date/m-p/310628#M114713 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>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.</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 27 Jan 2012 05:49:53 GMT https://community.qlik.com/t5/QlikView/convert-string-from-text-file-to-Date/m-p/310628#M114713 2012-01-27T05:49:53Z convert string from text file to Date https://community.qlik.com/t5/QlikView/convert-string-from-text-file-to-Date/m-p/310629#M114714 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Use the following expression:</P><P></P><P>Date(Date#(Timestamp, 'DD-MMM-YY')) AS DateField</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Fri, 27 Jan 2012 05:52:45 GMT https://community.qlik.com/t5/QlikView/convert-string-from-text-file-to-Date/m-p/310629#M114714 Miguel_Angel_Baeyens 2012-01-27T05:52:45Z Re: convert string from text file to Date https://community.qlik.com/t5/QlikView/convert-string-from-text-file-to-Date/m-p/310630#M114715 <HTML><HEAD></HEAD><BODY><P>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..</P><P></P><P>Thank you again sir!</P></BODY></HTML> Fri, 27 Jan 2012 06:18:03 GMT https://community.qlik.com/t5/QlikView/convert-string-from-text-file-to-Date/m-p/310630#M114715 2012-01-27T06:18:03Z