topic Re: date field conversion in Application Development and Automation Discussions

date field conversion

Former Member — Tue, 24 Apr 2007 09:42:59 GMT

hi gurus! can someone give me a tip on a date field conversion.

I have a field that comes YYYYMMDD but i want to convert to DD.MM.YYYY

Can someone help me on this

Thk, Regards

Re: date field conversion

Former Member — Tue, 24 Apr 2007 09:44:46 GMT

u can use the below statemnet

data: l_date(10).
data  = sy-datum.
write date to l_date using edit mask '__.__.____'.

Re: date field conversion

Former Member — Tue, 24 Apr 2007 09:44:48 GMT

make use of keyword

<b>write to</b>

Regards

Prabhu

Re: date field conversion

Former Member — Tue, 24 Apr 2007 09:45:51 GMT

data : v_date1 like sy-datum,
         v_date2(10).

v_date1 = sy-datum.

concatenate v_date1+6(2) v_date1+4(2) v_date1+0(4) into v_date2 separated by '.'.

write : v_date2.

Re: date field conversion

Former Member — Tue, 24 Apr 2007 09:50:11 GMT

Hi Joao,

Try this function Module, ' CONVERT_DATE_TO_INTERN_FORMAT '.

This will helps to change the format of the date as you wish.

Thanks.

reward If Helpful.

Re: date field conversion

Former Member — Tue, 24 Apr 2007 09:55:49 GMT

REPORT  Z_82235_TEST4                           .

data:  date1(8) type c,
       date2(10) type c.

       date1 = 'YYYYMMDD'.

CONCATENATE date1+6(2) date1+4(2) date1(4) INTO date2 separated by '.'.

.....................

you pass your date to date1 in place of 'yyyymmdd' and you will gate ur desired output on date2.