topic Re: Date Conversion in Application Development and Automation Discussions

Date Conversion

Former Member — Wed, 24 Jun 2009 10:04:25 GMT

Hi, I need to convert a date like this:

2001-07-24T00:00:00.0000000+02:00

in SAP format:

20010724

How can I do it?

There is a function module? THANKS

Re: Date Conversion

former_member302911 — Wed, 24 Jun 2009 10:11:29 GMT

Hi,

can try this simple code:



DATA A TYPE STRING VALUE '2001-07-24T00:00:00.0000000+02:00'.
DATA VA_DATA LIKE SY-DATUM.

REPLACE ALL OCCURENCES OF '-' IN A WITH ''.
VA_DATA = A(8).
WRITE VA_DATA.

Angelo.

Re: Date Conversion

kesavadas_thekkillath — Wed, 24 Jun 2009 10:11:33 GMT

if your format consists of first 10 characters as date always then u can write your logic.

say text is your variable.

extract like text+0(9).

pass it to FM CONVERT_DATE_TO_INTERNAL to convert it

Re: Date Conversion

kesavadas_thekkillath — Wed, 24 Jun 2009 10:13:32 GMT

if your format consists of first 10 characters as date always then u can write your logic.

say text is your variable.

extract like text+0(9).

pass it to FM CONVERT_DATE_TO_INTERNAL to convert it

Re: Date Conversion

kesavadas_thekkillath — Wed, 24 Jun 2009 10:13:33 GMT

if your format consists of first 10 characters as date always then u can write your logic.

say text is your variable.

extract like text+0(9).

pass it to FM CONVERT_DATE_TO_INTERNAL to convert it

Re: Date Conversion

Former Member — Wed, 24 Jun 2009 10:23:06 GMT

Hi,

try this TZ_GLOBAL_TO_LOCAL.

here u pass date and time ,u'll get according to ur format.

Regards,

Ranjitha.