topic Re: date conversion in Application Development and Automation Discussions

date conversion

Former Member — Mon, 03 Sep 2007 05:07:28 GMT

Hi all,

I want to convert my date format. From DD/MM/YYYY to DD/MM/YY. I am doing this using concatenation. Can any body tell me how to do this using 'WRITE TO'. Or please suggest me if any Function Module exists.

Thanks.

Munagala.

Re: date conversion

kiran_k8 — Mon, 03 Sep 2007 05:10:06 GMT

Praveen,

Try this Fn Module

DATE_CONV_EXT_TO_INT - user formatted date is converted to system date

K.Kiran.

Re: date conversion

former_member194669 — Mon, 03 Sep 2007 05:12:37 GMT

Hi,


data: lv_date(8)   type c.
write sy-datum to lv_date DD/MM/YY.

lv_date contains the date with  DD/MM/YY

a®

Re: date conversion

Former Member — Mon, 03 Sep 2007 05:13:48 GMT

Hi,

try this code

data: char type sy-datum.

char = sy-datum.

data: var(10) type c.

write char to var using edit mask '__/__/____'.

write:/ var.

clear: var.

concatenate sy-datum6(2) sy-datum4(2) sy-datum+2(2) into var.

skip.

write var using edit mask '__/__/__'.

thanks & regards,

Venkatesh

Re: date conversion

Former Member — Mon, 03 Sep 2007 05:19:17 GMT

Hi Praveena,

Anyways you are concatenating into a variable use that variable.

Concatenate date10(2) date12(2) date1+6(2) into date2.

Use date2.

Regards,

Ravi G

Re: date conversion

Former Member — Mon, 03 Sep 2007 05:25:56 GMT

Hi Praveen,

This is very simple...

Use like this:

WRITE d_temp TO field2 DD/MM/YY.

Thanks and Best Regards,

Vikas Bittera.

Re: date conversion

Former Member — Mon, 03 Sep 2007 05:26:30 GMT

Hi Praveen,

This is very simple...

Use like this:

WRITE d_temp TO field2 DD/MM/YY. d_temp being a field of type d.

Thanks and Best Regards,

Vikas Bittera.

Re: date conversion

Former Member — Mon, 03 Sep 2007 05:26:41 GMT

If it is a character field do like this...

DATA : DATE(10) VALUE '22/07/2007',

OUTDATE(8).

WRITE : DATE+0(6) TO OUTDATE(6),

DATE8(2) TO OUTDATE6(2).

WRITE : / OUTDATE.

But if it is a date field (type d or like sy-datum) do like this

DATA : IDATE LIKE SY-DATUM.

IDATE = SY-DATUM.

WRITE : / IDATE DD/MM/YY.

reagrds

shiba dutta