topic Convert numeric fields to date in QlikView https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163149#M36353 <HTML><HEAD></HEAD><BODY><P>Goodmorning,</P><P>I have some problems converting numeric fields that contains dates (For example : 20090130) within the Loading script. I want to convert this to a valid date field, like 'YYYY-MM-DD'.</P><P>Any suggestions how to solve this easily?</P><P></P></BODY></HTML> Tue, 24 Nov 2009 15:14:53 GMT 2009-11-24T15:14:53Z Convert numeric fields to date https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163149#M36353 <HTML><HEAD></HEAD><BODY><P>Goodmorning,</P><P>I have some problems converting numeric fields that contains dates (For example : 20090130) within the Loading script. I want to convert this to a valid date field, like 'YYYY-MM-DD'.</P><P>Any suggestions how to solve this easily?</P><P></P></BODY></HTML> Tue, 24 Nov 2009 15:14:53 GMT https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163149#M36353 2009-11-24T15:14:53Z Convert numeric fields to date https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163150#M36354 <HTML><HEAD></HEAD><BODY><P>You can try date('FieldName','YYYY-MM-DD') as FieldName</P><P>or date(date#('FieldName','YYYYMMDD'),'YYYY-MM-DD') will work if the first part does not.</P><P>Kind Regards,</P><P>Footsie</P></BODY></HTML> Tue, 24 Nov 2009 15:18:22 GMT https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163150#M36354 2009-11-24T15:18:22Z AW:Convert numeric fields to date https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163151#M36355 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can try:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">date(date#([YOUR_DATE], 'YYYYMMDD'), 'YYYY-MM-DD')</PRE></BLOCKQUOTE><BR /><BR /> <P></P><P>Regards.</P><P></P><P>€: Too slow <IMG alt="Stick out tongue" src="http://community.qlik.com/emoticons/emotion-4.gif" /></P></BODY></HTML> Tue, 24 Nov 2009 15:23:11 GMT https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163151#M36355 2009-11-24T15:23:11Z Convert numeric fields to date https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163152#M36356 <HTML><HEAD></HEAD><BODY><P>Thanks, this worked!!</P><P>Best regards.</P></BODY></HTML> Tue, 24 Nov 2009 15:23:28 GMT https://community.qlik.com/t5/QlikView/Convert-numeric-fields-to-date/m-p/163152#M36356 2009-11-24T15:23:28Z