topic Convert expanded date ? in Application Development and Automation Discussions

Convert expanded date ?

Former Member — Fri, 05 Dec 2008 11:40:07 GMT

Dear All,

How to Convert the date which is in the format November 11, 2008 to MM/DD/YYYY ?

Regards,

Deepu.k

Re: Convert expanded date ?

Mohamed_Mukhtar — Fri, 05 Dec 2008 11:49:46 GMT

hi,

See the pseudo code, it might be helpful to you

DATA : wa_date(40) VALUE 'November 11, 2008',
       wa_date1(10),
       var1(15),
       var2(3),
       var3(4),
       month(2).

SPLIT wa_date AT space INTO var1 var2 var3.
CASE var1.
  WHEN 'January'.
    month = 01.
  WHEN 'February'.
    month = 02.
  WHEN 'March'.
    month = 03.
  WHEN 'April'.
    month = 04.
  WHEN 'May'.
    month = 05.
  WHEN 'June'.
    month = 06.
  WHEN 'July'.
    month = 07.
  WHEN 'August'.
    month = 08.
  WHEN 'September'.
    month = 09.
  WHEN 'October'.
    month = 10.
  WHEN 'November'.
    month = 11.
  WHEN 'December'.
    month = 12.
ENDCASE.

CONCATENATE month var2+0(2)  var3 INTO wa_date1 SEPARATED BY '/'.

WRITE wa_date1.

or As one of our friend suggested u can do in the follwowing way.

DATA : wa_date(40) VALUE 'November 11, 2008',
       wa_date1(10),
       var1(15),
       var2(3),
       var3(4),
       month(2).

SPLIT wa_date AT space INTO var1 var2 var3.

SELECT SINGLE  mnr FROM t247 INTO month WHERE spras = sy-langu AND ltx = var1.

CONCATENATE month var2+0(2) var3 INTO wa_date1 SEPARATED BY '/'.

WRITE wa_date1.

Thanks & Regards

Edited by: Always Learner on Dec 5, 2008 12:57 PM

Re: Convert expanded date ?

Former Member — Fri, 05 Dec 2008 11:51:43 GMT

check table T247

Re: Convert expanded date ?

Former Member — Fri, 05 Dec 2008 11:54:36 GMT

you can use convert_date_to_external FM to change it in ur required format.

also:

CONVERSION_EXIT_PDATE_OUTPUT

Eg: input = 24012008 and output = 24.01.2008

CONVERT_DATE_FORMAT

Eg: input = 20080201 and output = 01.02.2008

CONVERSION_EXIT_SDATE_OUTPUT

Eg: input = 20070201 and output = 01.FEB.2007

CONVERSION_EXIT_IDATE_INPUT

Eg: input = 01.02.2008 and Output = 20080201

CONVERSION_EXIT_LDATE_OUTPUT

Eg: input = 20070301 and output = 01. March 2007

CONVERSION_EXIT_PDATE_OUTPUT

Eg: input = 20070301 and output = 03.01.2007

Pari