How to convert date format to MM/DD/YYYY

[Former Member]

Hi,

How to convert date format to MM/DD/YYYY.

Thanks,

Senthil

[Former Member]

WRITE: sy-datum MM/DD/YYYY

.

[Former Member]

Hi Venkat,

I want to assign MM/DD/YYYY foramt to another variable. So is there is any function is available otherwise how to convert apart from using write statement.

Thanks,

Senthil

[Former Member]

Senthil ,

You can also try this

Date = YYYYMMDD

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

Cheers

Raghava

[former_member291971]

Hi,

you should need to use '+' sign in the concatenate date else it throws an error.

[Former Member]

data : l_date(10) type c .

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

write : l_date.

[Former Member]

hi,

tri with this function module

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

cheers,

sasi

[former_member811213]

it is displaying current system date here.