Date Conversion Function Modules YYYYMMDD to MM/DD/YYYY

[Former Member]

Hi,

I have a requirement to Conver the Dats from format: YYYYMMDD into the Format : MM/DD/YYYY. Can you please suggest me a suitabble Standard Function Module if exists? If not please suggest me a solution for this data conversion.

Thanks,

Rajan.SA

[Former Member]

Hi,

You can use WRITE FORMATING.

Here the sample code:

DATA: BEGDA       TYPE TEXT10,
      ENDDA       TYPE SY-DATUM.

  WRITE SY-DATUM TO BEGDA MM/DD/YYYY.
  WRITE SY-DATUM TO ENDDA MM/DD/YYYY.

And of course you can use other format, like:

... DD/MM/YY

... MM/DD/YY

... DD/MM/YYYY

... MM/DD/YYYY

... DDMMYY

... MMDDYY

... YYMMDD

Or you can use concatenate statement:

    concatenate SY-DATUM+4(2) SY-DATUM+6(2)
    SY-DATUM(4) INTO BEGDA separated by '/'.

Regards,

[RichHeilman]

Use function module CONVERT_DATE_TO_EXTERNAL. This will convert the date to the user specific format. So if your user specific format is mm/dd/yyyy, then this is all you need.

Regards,

RIch Heilman

[Former Member]

I used FM CONVERT_DATE_TO_EXTERNAL to convert the date format into MMDDYY check it if it helps.