06-08-2007 7:00 AM
can any one tell meFunction module to convert date form yyyy/mm/dd to mm/dd/yyyy format
06-08-2007 7:05 AM
Hi,
CONVERT_DATE_TO_EXTERNAL --> Converts internal date to user-specific format.
Regards
Suresh.d
06-08-2007 7:04 AM
Hi,
CONVERT_DATE_TO_EXTERNAL --> Converts internal date to user-specific format.
CONVERT_DATE_TO_INTERNAL --> Viceversa
Regards
Sudheer
06-08-2007 7:05 AM
Hi,
CONVERT_DATE_TO_EXTERNAL --> Converts internal date to user-specific format.
Regards
Suresh.d
06-08-2007 7:21 AM
hai
u can do it without using the function.....
p_date = input date variable
c_date = output date variable
<b>form convert_to_date_format using p_date
changing c_date.
data: tmp_date(10).
concatenate p_date6(2) '.' p_date4(2) '.' p_date+0(4) into tmp_date.
c_date = tmp_date.
endform. " convert_TO_date_format</b>
i think it must be help ful to u
regard
nawa
06-08-2007 7:35 AM
DATA : V_DATE(10).
CONCATENATE SY-DATUM4(2) SY-DATUM6(2) SY-DATUM+0(4) INTO V_DATE SEPARATED BY '/'.
WRITE : / V_DATE.
REGARDS
SHIBA DUTTA
06-08-2007 7:42 AM
hi
good
try this
report zrich_0001.
tables s002.
data ilikp type table of likp.
ranges: r_datum for sy-datum.
select-options: s_spbup for s002-spbup.
start-of-selection.
r_datum-sign = 'I'.
r_datum-option = 'BT'.
r_datum-low = s_spbup-low.
r_datum-low+6(2) = '01'.
if s_spbup-high is not initial.
r_datum-high = s_spbup-high.
r_datum-high+6(2) = '01'.
else.
r_datum-high = r_datum-low.
endif.
r_datum-high4(2) = r_datum-high4(2) + 1.
r_datum-high = r_datum-high - 1.
append r_datum.
select * into table ilikp from likp
where erdat in r_datum.
thanks
mrutyun^