topic Decoding SAP Dates in QlikView https://community.qlik.com/t5/QlikView/Decoding-SAP-Dates/m-p/213406#M67151 <HTML><HEAD></HEAD><BODY><P>Pax,</P><P>I had the same problem a year ago, but the format was specific to one SAP table I was using and since I found the answer in a ABAP forum because ABAPers apparently have to do the same thing, I would call this a design issue in SAP.</P><P>Most SAP tables have fields with dates that have a standard date format.</P><P>Regards.</P></BODY></HTML> Sat, 12 Feb 2011 21:19:06 GMT pover 2011-02-12T21:19:06Z Decoding SAP Dates https://community.qlik.com/t5/QlikView/Decoding-SAP-Dates/m-p/213405#M67150 <HTML><HEAD></HEAD><BODY><P>Dear All.</P><P>I came accross a project where we were to fetch the data of relevant dates from SAP.</P><P>We came across the dates mentioned as 79888790.</P><P>After doing lots of research we found that if you substract the number mentioned in date column from 99999999 you will get the perfect date.</P><P>As in 99999999 - 79888790 = 20111209.</P><P>Which you can then seperate.</P><P>if there are any different ways of decoding the dates in SAP, please share.</P></BODY></HTML> Fri, 11 Feb 2011 20:23:15 GMT https://community.qlik.com/t5/QlikView/Decoding-SAP-Dates/m-p/213405#M67150 2011-02-11T20:23:15Z Decoding SAP Dates https://community.qlik.com/t5/QlikView/Decoding-SAP-Dates/m-p/213406#M67151 <HTML><HEAD></HEAD><BODY><P>Pax,</P><P>I had the same problem a year ago, but the format was specific to one SAP table I was using and since I found the answer in a ABAP forum because ABAPers apparently have to do the same thing, I would call this a design issue in SAP.</P><P>Most SAP tables have fields with dates that have a standard date format.</P><P>Regards.</P></BODY></HTML> Sat, 12 Feb 2011 21:19:06 GMT https://community.qlik.com/t5/QlikView/Decoding-SAP-Dates/m-p/213406#M67151 pover 2011-02-12T21:19:06Z