‎2006 Nov 28 4:36 AM
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.
‎2006 Nov 28 4:37 AM
‎2006 Nov 28 4:37 AM
‎2006 Nov 28 4:39 AM
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
‎2006 Nov 28 4:39 AM
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
‎2006 Nov 28 4:41 AM
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
‎2006 Nov 28 4:41 AM
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