topic Re: How to convert Serial number back to date? in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432925#M801737 <HTML><HEAD></HEAD><BODY><P>What date is 24181 suppose to be?</P></BODY></HTML> Tue, 21 Nov 2017 13:02:48 GMT sunny_talwar 2017-11-21T13:02:48Z How to convert Serial number back to date? https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432924#M801736 <HTML><HEAD></HEAD><BODY><P>Hi Everyone, I am new to Qlik View.<IMG __jive_id="183987" alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183987_Untitled.png" style="height: 405px; width: 620px;" /></P><P>How to convert Serial number back to date??</P><P>I am failing to convert it, i used "</P><P>Date(Floor(Num#(YM, '##')), 'DD/MM/YYYY') as Date, and Date(Num#(YM, '##'), 'DD/MM/YYYY') as Date, " they are resulting to 1966 which is wrong.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432924#M801736 Anonymous 2020-11-25T16:16:04Z Re: How to convert Serial number back to date? https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432925#M801737 <HTML><HEAD></HEAD><BODY><P>What date is 24181 suppose to be?</P></BODY></HTML> Tue, 21 Nov 2017 13:02:48 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432925#M801737 sunny_talwar 2017-11-21T13:02:48Z Re: How to convert Serial number back to date? https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432926#M801738 <HTML><HEAD></HEAD><BODY><P>The numbers shown in your YM field represent dates in 1966.</P></BODY></HTML> Tue, 21 Nov 2017 13:04:27 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432926#M801738 m_woolf 2017-11-21T13:04:27Z Re: How to convert Serial number back to date? https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432927#M801739 <HTML><HEAD></HEAD><BODY><P>Date(YM) should do the job. </P></BODY></HTML> Tue, 21 Nov 2017 13:05:42 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432927#M801739 Or 2017-11-21T13:05:42Z Re: How to convert Serial number back to date? https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432928#M801740 <HTML><HEAD></HEAD><BODY><P>This works for the data shown in your screenshot:</P><P><IMG alt="Convert Serial Back To Date thread282465.jpg" class="jive-image image-1" height="167" src="/legacyfs/online/184034_Convert Serial Back To Date thread282465.jpg" style="height: 167px; width: 252.697px;" width="253" /></P><P>But we most certainly run into trouble for 2015.</P><P></P><P>As Sunny already mentioned, we need the calculation logic behind those weird serial numbers to be able to create a conversion expression that works reliably in every situation. If you don't know the logic, can you please tell us where you got them from?</P><P></P><P>The numbers themselves tell us nothing, and even when taking into account what is shown in the first column of your screenshot, they may quickly become ambiguous. For example, 24181 could be Jan-2014 or Nov-2013.</P></BODY></HTML> Tue, 21 Nov 2017 13:29:22 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Serial-number-back-to-date/m-p/1432928#M801740 Peter_Cammaert 2017-11-21T13:29:22Z