How to interpret dates in Packed Decimal format

[rmuhuri]

To plan dates , I can only use Key figure ( Date format ) with data type DEC-Packed Number in BCD format . Unfortunately I am not being able to interpret the number

for example 01/01/2018 is represented as 736696 in the database tables . How do I convert 736696 to YYYYMMDD ?

[former_member186338 · Accepted solution]

How do I convert 736696 to YYYYMMDD ? - It's number of days since 01/01/0001

[rmuhuri]

thnaks guys for your answers .

Vadim : Your answer gave me a reference point

Victor : Thanks for the detailed answer , just that it did not work for me as I am using AMDP ( SQLScript) and they did not have such a similar function to ABAP

[Victor_Arroyo]

Hi,

You can use this function DATE_TO_CHAR()

Check this link: https://help.sap.com/doc/saphelp_tm80/8.0/en-US/1d/310eb0d0ee11d4b2e40050da385632/content.htm?no_cac...

Victor A.