topic Date Format Issue in Application Development and Automation Discussions

Date Format Issue

Former Member — Wed, 26 Jul 2006 09:49:04 GMT

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

Re: Date Format Issue

Former Member — Wed, 26 Jul 2006 09:51:15 GMT

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.

Re: Date Format Issue

Former Member — Wed, 26 Jul 2006 09:56:25 GMT

Hi Kishan,

Points awarded. How could I now convert;

01.09.2005 –> to -> 79949098.

Thanks,

Kishan

Re: Date Format Issue

Former Member — Wed, 26 Jul 2006 09:57:31 GMT

chk this

Re: Date Format Issue

Former Member — Wed, 26 Jul 2006 10:05:04 GMT

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