Date Format Issue

[Former Member]

Hi All,

In table TCURR field GDATU holds the date and this is in a different format;

79949098 –> the actual value is -> 01.09.2005

How could I convert 79949098 –> to -> 01.09.2005 ?

Thanks,

Kishan

[Former Member]

REPORT ychatest.

TABLES:tcurr.
 
DATA: valid_from_date LIKE sy-datum.
 
SELECT SINGLE gdatu FROM tcurr INTO tcurr-gdatu.
 
CONVERT INVERTED-DATE tcurr-gdatu INTO DATE valid_from_date.
 
WRITE : valid_from_date.

[Former Member]

Hi Kishan,

Points awarded. How could I now convert;

01.09.2005 –> to -> 79949098.

Thanks,

Kishan

[Former Member]

Hi Kishan,

Check the Field in that TAble whether there is any COnversion Routine Written. If yes then you can find what logic have they used to convert it to that format .

Hope it helps you..........

Cheers,

Prashanth

[Former Member]

chk this