topic Re: date converting in Application Development and Automation Discussions

date converting

Former Member — Fri, 23 May 2008 12:47:08 GMT

Hi All,

How to convert the date 20080523 into 05/23/2008. pls provide me the code.

Regards

Sami

Re: date converting

Former Member — Fri, 23 May 2008 12:50:56 GMT

Hi,

data: v_date type sy-datum value '20080523'.

data: v_result(10).

concatenate v_date4(2) v_date6(2) v_date+0(4) into v_result separated by '/'.

write:/ v_result.

Edited by: Velangini Showry Maria Kumar Bandanadham on May 23, 2008 2:52 PM

Re: date converting

Former Member — Fri, 23 May 2008 12:51:44 GMT

Hi,

You can use this function module:

CONVERT_DATE_TO_EXTERNAL

in import the variable should be of char type.

Re: date converting

Former Member — Fri, 23 May 2008 12:51:51 GMT

Hi,

Check the code below:

data: v_var1(10) type c,
        v_var2 type sy-datum.

v_var2 = sy-datum.

CONCATENATE v_var2+4(2) '/' v_var2+6(2) '/' v_var2+0(4) INTO v_var1.

Regards

Kannaiah

Re: date converting

former_member125661 — Fri, 23 May 2008 12:54:57 GMT

Use write Statment:

data : date(10).

write sy-datum to date mm/dd/yyyy. " writes 20080924 as 09/24/2008 in date.

Re: date converting

Former Member — Fri, 23 May 2008 12:57:39 GMT

Also need add some code for this:

DATA: X TYPE D VALUE '20080523',
      Y(10) .

WRITE X MM/DD/YYYY TO Y.
REPLACE ALL OCCURRENCES OF '.' IN Y WITH '/'.
WRITE Y.

Re: date converting

Former Member — Fri, 23 May 2008 13:01:24 GMT

Hello,

Use this:


WRITE sy-datum TO lv_variable MM/DD/YYYY.

The content of a data object of type d is interpreted as a valid date in the format YYYYMMDD and is output as follows for the individual additions:

DD/MM/YY and MM/DD/YY:

Both additions have the same effect. The date output has a two-digit year value and a separator. The separator and the order are taken from the definition for date output in the user master record.

DD/MM/YYYY und MM/DD/YYYY:

Both additions have the same effect. The date output has a four-digit year value and separator. The separator and the order are taken from the definition for date output in the user master record.

DDMMYY und MMDDYY:

Both additions have the same effect. The date output has a two-digit year value and no separator. The order is taken from the definition for date output in the user master record.

YYMMDD:

This addition provides a date output with a two-digit year value without a separator in the format YYMMDD.

If the output length is defined implicitly or specified using len, this is used. If it is too short, the edited output is cut off to the right. If the output length is specified using * or **, it is set to the length of the specified edit mask (6, 8, or 10).

Note

The behavior for abbreviation differs from the output of a data in accordance with the user master record, where the separator is removed first and then cut off.

Regards,

Re: date converting

Former Member — Fri, 23 May 2008 21:43:21 GMT

Hi, Check this out.

data: date1 type sy-datum value '20080523'.

data:result(10).

concatenate date14(2) date16(2) date1+0(4) into result separated by '/'.

reward me if it helps.

Kinjal