06-29-2007 7:54 AM
Hii can anyone tell me which function module is used to convert no of days into days,month & year....
SHOAIB
06-29-2007 7:56 AM
Hi
Check the following fun modules
DAYS_BETWEEN_TWO_DATES
LEAP_DAYS_BETWEEN_TWO_DATES
HR_SEN_CALE_DAYS_DATE
ISB_DAYS_BETWEEN_TWO_DATES
FIMA_DAYS_BETWEEN_TWO_DATES
FIMA_DAYS_BETWEEN_TWO_DATES_2
FIMA_LEAP_DAYS_BETWEEN_2_DATES
Kishi.
06-29-2007 8:00 AM
hi ,
just check this code this might help u ....
DATA: V_INPUT(4) VALUE '7093'.
DATA: V_DATE TYPE SYDATUM.
DATA: V_OUTPUT TYPE CHAR10.
CONCATENATE '200' V_INPUT(1) '0101' INTO V_DATE.
V_DATE = V_DATE + V_INPUT+1(3) - 1.
WRITE V_DATE TO V_OUTPUT MM/DD/YYYY.
WRITE: / V_OUTPUT.
regards
reena
06-29-2007 8:00 AM
hi rehman,
i am not sure whether any FM exists that returns no.of days ,months and years. But there is a FM FIMA_DAYS_AND_MONTHS_AND_YEARS which will return no of days, yrs, months b/w two dates.
regards,
alson
06-29-2007 8:07 AM
06-29-2007 1:36 PM
Hi,
FM: 'FIMA_DAYS_AND_MONTHS_AND_YEARS'
Ex.
REPORT ZDATEDIFF.
DATA: EDAYS LIKE VTBBEWE-ATAGE,
EMONTHS LIKE VTBBEWE-ATAGE,
EYEARS LIKE VTBBEWE-ATAGE.
PARAMETERS: FROMDATE LIKE VTBBEWE-DBERVON,
TODATE LIKE VTBBEWE-DBERBIS DEFAULT SY-DATUM.
call function 'FIMA_DAYS_AND_MONTHS_AND_YEARS'
exporting
i_date_from = FROMDATE
i_date_to = TODATE
I_FLG_SEPARATE = ' '
IMPORTING
E_DAYS = EDAYS
E_MONTHS = EMONTHS
E_YEARS = EYEARS.
WRITE:/ 'Difference in Days ', EDAYS.
WRITE:/ 'Difference in Months ', EMONTHS.
WRITE:/ 'Difference in Years ', EYEARS.
INITIALIZATION.
FROMDATE = SY-DATUM - 60.
Regards,
Bhaskar