https://community.qlik.com/t5/QlikView/How-do-I-convert-to-decimal-number-to-date/m-p/1679518#M592546 <P>Dear Community,</P><P>How do I convert&nbsp; 20.200.429.105.959 into YYYY/MM/DD which equates 2020/04/29.&nbsp; Any response is very much appreciated.</P><P>or alternatively as</P><P>Week( [Shipping Date]) as Week,<BR />month( [Delivery Date]) as Month,<BR />year( [Shipping Date]) as Year,</P><P><BR />Regards</P><P>Samson O'David</P><P>&nbsp;</P> Wed, 26 Feb 2020 14:49:51 GMT sodavid 2020-02-26T14:49:51Z https://community.qlik.com/t5/QlikView/How-do-I-convert-to-decimal-number-to-date/m-p/1679518#M592546 <P>Dear Community,</P><P>How do I convert&nbsp; 20.200.429.105.959 into YYYY/MM/DD which equates 2020/04/29.&nbsp; Any response is very much appreciated.</P><P>or alternatively as</P><P>Week( [Shipping Date]) as Week,<BR />month( [Delivery Date]) as Month,<BR />year( [Shipping Date]) as Year,</P><P><BR />Regards</P><P>Samson O'David</P><P>&nbsp;</P> Wed, 26 Feb 2020 14:49:51 GMT https://community.qlik.com/t5/QlikView/How-do-I-convert-to-decimal-number-to-date/m-p/1679518#M592546 sodavid 2020-02-26T14:49:51Z https://community.qlik.com/t5/QlikView/How-do-I-convert-to-decimal-number-to-date/m-p/1679530#M592547 <P>use</P><P>date(timestamp#(ShippingDate, 'YY.YYM.MDD.hhm.mss'),'YYYY/MM/DD') as ShippingDate</P><P>Regards</P> Wed, 26 Feb 2020 15:12:30 GMT https://community.qlik.com/t5/QlikView/How-do-I-convert-to-decimal-number-to-date/m-p/1679530#M592547 martinpohl 2020-02-26T15:12:30Z https://community.qlik.com/t5/QlikView/How-do-I-convert-to-decimal-number-to-date/m-p/1679532#M592548 <P>Excellent! Thanks a mil!<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span></P> Wed, 26 Feb 2020 15:18:53 GMT https://community.qlik.com/t5/QlikView/How-do-I-convert-to-decimal-number-to-date/m-p/1679532#M592548 sodavid 2020-02-26T15:18:53Z