topic Re: Convert 14 digit-decimal to Date in QlikView https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449357#M802954 <HTML><HEAD></HEAD><BODY><P>May be as below:</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date#</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Left</SPAN><SPAN style="font-size: 8pt;">( 20160128155600,8),'YYYY-MM-DD') </SPAN></P></BODY></HTML> Thu, 09 Nov 2017 19:56:09 GMT trdandamudi 2017-11-09T19:56:09Z Convert 14 digit-decimal to Date https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449355#M802952 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P></P><P>I have 14 digit values which is in decimal ( StartDate = 20160128155600) which i need to convert to Date.</P><P></P><P>I've used Date(Date# (StartDate, 'YYY-MM-DD'), <SPAN style="font-size: 13.3333px;"> 'YYY-MM-DD') as 'Start Date' but it didn't return anything.&nbsp; </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Can you please assist me with this?&nbsp; Thank you in advance.<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449355#M802952 xarapre7 2020-11-25T16:16:04Z Re: Convert 14 digit-decimal to Date https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449356#M802953 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Date(Date#(Left(StartDate, 8), 'YYYYMMDD'), 'YYYY-MM-DD') as StartDate</STRONG></P></BODY></HTML> Thu, 09 Nov 2017 19:54:57 GMT https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449356#M802953 sunny_talwar 2017-11-09T19:54:57Z Re: Convert 14 digit-decimal to Date https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449357#M802954 <HTML><HEAD></HEAD><BODY><P>May be as below:</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date#</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Left</SPAN><SPAN style="font-size: 8pt;">( 20160128155600,8),'YYYY-MM-DD') </SPAN></P></BODY></HTML> Thu, 09 Nov 2017 19:56:09 GMT https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449357#M802954 trdandamudi 2017-11-09T19:56:09Z Re: Convert 14 digit-decimal to Date https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449358#M802955 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny T!&nbsp; It worked.</P></BODY></HTML> Thu, 09 Nov 2017 21:10:08 GMT https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449358#M802955 xarapre7 2017-11-09T21:10:08Z Re: Convert 14 digit-decimal to Date https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449359#M802957 <HTML><HEAD></HEAD><BODY><P>Awesome, please close the thread by marking correct response.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 09 Nov 2017 23:30:18 GMT https://community.qlik.com/t5/QlikView/Convert-14-digit-decimal-to-Date/m-p/1449359#M802957 sunny_talwar 2017-11-09T23:30:18Z