topic Problems converting a string to a date in QlikView https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159527#M34135 <HTML><HEAD></HEAD><BODY><P>Kris</P><P>Use Date(Date#([Planned Settlement Date], 'YYYYMMDD'), 'DD/MM/YYYY]') AS [Planned Settlement Date]</P><P>Jonathan</P></BODY></HTML> Fri, 13 Aug 2010 09:30:56 GMT jonathandienst 2010-08-13T09:30:56Z Problems converting a string to a date https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159526#M34134 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having a real issue with the conversion of a string field into a date. The original format of the field is 20090101 and I am attempting to use the Date function in the following way Date([Planned Settlement Date],'DD/MM/YYYY]') AS [Planned Settlement Date].....</P><P></P><P>However I am returning absolute rubbish for the year with the days and month looking correct i.e. 20090101 is coming out as 01/01/8474</P><P></P><P>Does anyone have any idea as to what maybe causing this????</P><P></P><P>Cheers</P><P></P><P>Kris</P><P></P></BODY></HTML> Fri, 13 Aug 2010 09:10:53 GMT https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159526#M34134 2010-08-13T09:10:53Z Problems converting a string to a date https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159527#M34135 <HTML><HEAD></HEAD><BODY><P>Kris</P><P>Use Date(Date#([Planned Settlement Date], 'YYYYMMDD'), 'DD/MM/YYYY]') AS [Planned Settlement Date]</P><P>Jonathan</P></BODY></HTML> Fri, 13 Aug 2010 09:30:56 GMT https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159527#M34135 jonathandienst 2010-08-13T09:30:56Z Problems converting a string to a date https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159528#M34136 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use MakeDate function as follows:</P><P>MakeDate(left([Planned Settlement Date],4),mid([Planned Settlement Date],5,2),right(left([Planned Settlement Date],2)) as [Planned Settlement Date]</P><P>hope this would help you. I didn't check Jonathan's one earlier...but yes that one is even easier.</P><P>Regards,</P><P>tresesco</P><P></P></BODY></HTML> Fri, 13 Aug 2010 09:40:37 GMT https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159528#M34136 tresB 2010-08-13T09:40:37Z Problems converting a string to a date https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159529#M34137 <HTML><HEAD></HEAD><BODY><P>Thank for your help that worked perfectly</P></BODY></HTML> Fri, 13 Aug 2010 09:56:43 GMT https://community.qlik.com/t5/QlikView/Problems-converting-a-string-to-a-date/m-p/159529#M34137 2010-08-13T09:56:43Z