topic date conversion 8 digits issue? in QlikView https://community.qlik.com/t5/QlikView/date-conversion-8-digits-issue/m-p/371409#M1175023 <HTML><HEAD></HEAD><BODY><P>Thanks neha. It worked for me quite well.</P><P></P><P>I guess this was some logic in the SAP data base.</P></BODY></HTML> Fri, 27 Apr 2012 12:23:24 GMT subin6600 2012-04-27T12:23:24Z date conversion 8 digits issue? https://community.qlik.com/t5/QlikView/date-conversion-8-digits-issue/m-p/371407#M1175021 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a date field in the data base&nbsp; as 80039583. How can we get this converted into the date field in Qlikview?</P><P>This date refers to 16.04.1996. Did anyone come across such issue??</P><P><BR />Appreciate your effort for the response.</P><P></P><P>Br</P><P>Subin</P></BODY></HTML> Fri, 27 Apr 2012 05:22:24 GMT https://community.qlik.com/t5/QlikView/date-conversion-8-digits-issue/m-p/371407#M1175021 subin6600 2012-04-27T05:22:24Z date conversion 8 digits issue? https://community.qlik.com/t5/QlikView/date-conversion-8-digits-issue/m-p/371408#M1175022 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use following formula:</P><P></P><P>(99999999 - Date_field) as Date_field</P><P></P><P>You will get date in 'YYYYMMDD' format. Convert it in suitable format by using Date() function.</P><P></P><P>Regards,</P><P>Neha</P></BODY></HTML> Fri, 27 Apr 2012 11:54:12 GMT https://community.qlik.com/t5/QlikView/date-conversion-8-digits-issue/m-p/371408#M1175022 2012-04-27T11:54:12Z date conversion 8 digits issue? https://community.qlik.com/t5/QlikView/date-conversion-8-digits-issue/m-p/371409#M1175023 <HTML><HEAD></HEAD><BODY><P>Thanks neha. It worked for me quite well.</P><P></P><P>I guess this was some logic in the SAP data base.</P></BODY></HTML> Fri, 27 Apr 2012 12:23:24 GMT https://community.qlik.com/t5/QlikView/date-conversion-8-digits-issue/m-p/371409#M1175023 subin6600 2012-04-27T12:23:24Z