topic Re: date convertion in Application Development and Automation Discussions

date convertion

Former Member — Thu, 21 May 2009 01:10:39 GMT

Hi ,

i need to change date from 04/05/2009 to 0 4 0 5 2 0 0 9 .

Re: date convertion

Former Member — Thu, 21 May 2009 01:14:50 GMT

HI..

Use Offsets to pick date month year from your date field and pass to your required field.

eg:

concatenate date0(2) date2(2) date+4(4) INTO varaiable_field9ur field).

Hope this helps.

Praveen

Edited by: praveen parasiya on May 21, 2009 3:15 AM

Re: date convertion

Former Member — Thu, 21 May 2009 01:16:41 GMT

can you give example how to do that ?

Re: date convertion

Former Member — Thu, 21 May 2009 01:22:43 GMT

Hi Check the format of date in ur system.

Try like below.

data d_date type datum.

data output type string.

data sep type c.

d_date = sy-datum.

concatenate d_date0(4) d_date4(2) d_date+6(2) INTO output separated by

sep.

write output.

Praveen

Re: date convertion

Former Member — Thu, 21 May 2009 02:06:00 GMT

Hi,

You can write the following code:

DATA: lv_date(10) TYPE c,

lv_temp(10) TYPE c.

lv_date = '04/05/2009'.

lv_temp = '/'.

REPLACE ALL OCCURRENCES OF lv_temp IN lv_date WITH ' '.

Hope this may be usefull..

Regards,

Prashant

Re: date convertion

Former Member — Thu, 21 May 2009 02:11:06 GMT

thanx for answer praveen parasiya .point rewarded

Edited by: Dev__D on May 21, 2009 4:11 AM

Re: date convertion

Former Member — Thu, 21 May 2009 03:45:39 GMT

hi,

if your this date 04/05/2009 is string format than you can achieve it as follows

data: olddate type string value '04/05/2009',
        newdate type string.

concatenate oldate0(1) oldate1(1) oldate3(1) oldate4(1) oldate6(1) oldate7(1) oldate8(1) oldate9(1) into newdate separated by space.

hope it helps