topic Re: Date Conversion Function Modules YYYYMMDD to MM/DD/YYYY in Application Development and Automation Discussions

Date Conversion Function Modules YYYYMMDD to MM/DD/YYYY

Former Member — Thu, 29 Mar 2007 00:43:28 GMT

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

Re: Date Conversion Function Modules YYYYMMDD to MM/DD/YYYY

Former Member — Thu, 29 Mar 2007 01:00:04 GMT

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,

Re: Date Conversion Function Modules YYYYMMDD to MM/DD/YYYY

RichHeilman — Thu, 29 Mar 2007 01:08:10 GMT

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

Re: Date Conversion Function Modules YYYYMMDD to MM/DD/YYYY

Former Member — Thu, 29 Mar 2007 01:38:41 GMT

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