Decoding SAP Dates

[#1]

Dear All.

I came accross a project where we were to fetch the data of relevant dates from SAP.

We came across the dates mentioned as 79888790.

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.

As in 99999999 - 79888790 = 20111209.

Which you can then seperate.

if there are any different ways of decoding the dates in SAP, please share.

[pover]

Pax,

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.

Most SAP tables have fields with dates that have a standard date format.

Regards.