topic date converison in Application Development and Automation Discussions

date converison

Former Member — Wed, 18 Oct 2006 08:33:09 GMT

i need to change the date conversion to mm/dd/yyyy how can i do that

Re: date converison

Former Member — Wed, 18 Oct 2006 08:34:37 GMT

Please try this FM.

CONVERSION_EXIT_INVDT_INPUT

CONVERSION_EXIT_INVDT_OUTPUT

1) CONVERT_DATE_TO_INTERN_FORMAT Converts a date to internal format

2) CONVERT_FIELD_TO_EXTERN_FORMAT Converts a field from internal to external format

3) CONVERT_FIELD_TO_INTERN_FORMAT Converts a field from external to internal format

Reward with points for helpful answers

Cheers

Alfred

Re: date converison

Former Member — Wed, 18 Oct 2006 08:36:41 GMT

Try using,

CONVERT_DATE_TO_EXTERNAL

It Converts date from system storage format to users specified display format .

Try this,

<b>WRITE wa_olddate TO wa_newdate MM/DD/YYYY</b>.

hope this helps!

best regards,

Thangesh

Re: date converison

Former Member — Wed, 18 Oct 2006 08:39:13 GMT

HI,

Date = YYYYMMDD

Concatenate date4(2) ‘ /’ date6(2) ‘/’ date(4) into Date2.

data : l_date(10) type c .

concatenate sy-datum6(2) '/' sy-datum4(2) '/' sy-datum(4) into l_date.

write : l_date.

data :l_date(10) type c

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

DATE_INTERNAL = SY-DATUM

IMPORTING

DATE_EXTERNAL = l_date.

this function module converts date from 20050601 to external format which is specified in user profile.

Regards,

Laxmi.

Re: date converison

shishupalreddy — Wed, 18 Oct 2006 08:45:35 GMT

hi,

Use the following piece of code.

DATA: L_DATE(10).

WRITE sy-datum to l_Date mm/dd/yyyy.

regards,

Re: date converison

Former Member — Wed, 18 Oct 2006 08:47:13 GMT

good

no function module can help you to change the date conversiton,

you have to store your complete date in a variable and split the three part and store in different variable.Take another variable and store only '/'.

use CONCATENAE statement to contatenate all the characters and display them using another character variable.

thanks

mrutyun^