topic I read text as dates in QlikView https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476170#M1136736 <HTML><HEAD></HEAD><BODY><P>However the year comes up like 56989 . What am I doing wrong?</P></BODY></HTML> Mon, 04 Nov 2013 12:10:33 GMT 2013-11-04T12:10:33Z I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476170#M1136736 <HTML><HEAD></HEAD><BODY><P>However the year comes up like 56989 . What am I doing wrong?</P></BODY></HTML> Mon, 04 Nov 2013 12:10:33 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476170#M1136736 2013-11-04T12:10:33Z Re: I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476171#M1136737 <HTML><HEAD></HEAD><BODY><P>Probably using the wrong date format string. Post the text of a date here and somebody can show you what to use.</P></BODY></HTML> Mon, 04 Nov 2013 12:12:35 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476171#M1136737 Gysbert_Wassenaar 2013-11-04T12:12:35Z Re: I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476172#M1136738 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="78"><TBODY><TR><TD height="19" width="78">20140518</TD></TR><TR><TD height="19">20140702</TD></TR><TR><TD height="19">20140911</TD></TR></TBODY></TABLE><P></P><P></P><P>This an example of the format I try to read as Date (Periode) as Periode,</P></BODY></HTML> Mon, 04 Nov 2013 12:16:23 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476172#M1136738 2013-11-04T12:16:23Z Re: I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476173#M1136739 <HTML><HEAD></HEAD><BODY><P>I doesn't really show here but in the excel sheet the numbers are stored as text.</P></BODY></HTML> Mon, 04 Nov 2013 12:17:40 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476173#M1136739 2013-11-04T12:17:40Z Re: I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476174#M1136740 <HTML><HEAD></HEAD><BODY><P>Date will treat the number as the number of days since 31-12-1899. What you need is to treat Periode as a string using the date# function: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">date#(Periode, 'YYYYMMDD')</SPAN></P></BODY></HTML> Mon, 04 Nov 2013 12:22:38 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476174#M1136740 Gysbert_Wassenaar 2013-11-04T12:22:38Z Re: I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476175#M1136741 <HTML><HEAD></HEAD><BODY><P>That worked 100% .. Thanks!!!</P></BODY></HTML> Mon, 04 Nov 2013 12:26:14 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476175#M1136741 2013-11-04T12:26:14Z Re: I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476176#M1136742 <HTML><HEAD></HEAD><BODY><P>However there is a 0 at the top for all the missing cases...</P></BODY></HTML> Mon, 04 Nov 2013 12:27:48 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476176#M1136742 2013-11-04T12:27:48Z Re: I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476177#M1136743 <HTML><HEAD></HEAD><BODY><P>If you only want the year from the format you provided why not simply do "Left( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Periode </SPAN>, 4 )"?</P></BODY></HTML> Mon, 04 Nov 2013 19:46:15 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476177#M1136743 andrewpettit 2013-11-04T19:46:15Z Re: I read text as dates https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476178#M1136744 <HTML><HEAD></HEAD><BODY><P>I will check it out when I got time! Thanks</P></BODY></HTML> Tue, 05 Nov 2013 10:50:31 GMT https://community.qlik.com/t5/QlikView/I-read-text-as-dates/m-p/476178#M1136744 2013-11-05T10:50:31Z