topic Re: date conversion in Application Development and Automation Discussions

date conversion

Former Member — Tue, 28 Nov 2006 04:36:20 GMT

hai all,

i need a conversion of date format.

in my flat file i having the format as 2006-11-27

but i need it in 27.11.2006.

plz help me.

points will be rewarded . thnx in advance.

Re: date conversion

gopi_narendra — Tue, 28 Nov 2006 04:37:18 GMT

Use the FM : CONVERSION_EXIT_PDATE_OUTPUT

Regards

- Gopi

Re: date conversion

Former Member — Tue, 28 Nov 2006 04:39:08 GMT

take variables V1, V2, V3.

V1 = date+0(4).

V2 = date+4(2) or 5(2). Check it

V3 = date+6(2) or 7(2). check it.

Concatenate V3 V2 V1 into date separated by '.'

Now, date will have DD.MM.YYYY

Re: date conversion

Former Member — Tue, 28 Nov 2006 04:39:20 GMT

Hi,

Check this..

DATA: V_DATE TYPE SYDATUM.

DATA: V_CHAR(10).

V_DATE = SY-DATUM.

CONCATENATE V_DATE6(2) '.' V_DATE4(2) '.' V_DATE(4) INTO V_CHAR.

WRITE: / V_CHAR.

Thanks,

Naren

Re: date conversion

Former Member — Tue, 28 Nov 2006 04:41:32 GMT

hi,

use this..

if p_date = '2006-11-27'.

<b>concatenate p_date8(2) p_date5(2) p_date+0(4) seperated by ' .'.</b>

rewrd points if helpful.

rgds,

ajith

Re: date conversion

anversha_s — Tue, 28 Nov 2006 04:41:48 GMT

hi,

hope u have sydatum type field with u.

data:lcdate(11).

call function 'converstion_exit_idate_output'
exporting
input = sy-datum
importing
output = lcdate.
 
concatenate lcdate(2) lcdate+2(3) lcdate+5(4) into lcdate seperated by '.'.

rgds

Anver