2008 Feb 06 6:13 AM
hi experts
i have two dates in abap form, like yyyymmdd how can i get the number of months beetwen these two dates.
thanks
amit
2008 Feb 06 6:16 AM
hi
u can use function module
MONTHS_BETWEEN_TWO_DATES
2008 Feb 06 6:16 AM
2008 Feb 06 6:17 AM
Hi Amit,
Use the FM RP_CALC_DATE_IN_INTERVAL.
This will help you to add / subtract days , years , months between the given dates.
Reward If Useful.
Regards,
Chitra
2008 Feb 06 6:17 AM
2008 Feb 06 6:18 AM
2008 Feb 06 6:22 AM
Hi,
Check this code,
DATA : DATE1 LIKE SY-DATUM VALUE '19830125',
DATE2 LIKE SY-DATUM VALUE '20070219',
DAYS1 TYPE I,
WEEK1 TYPE I,
MONTH1 TYPE I,
YEAR1 TYPE I,
C_YEARS1 TYPE I.
CALL FUNCTION 'HR_99S_INTERVAL_BETWEEN_DATES'
EXPORTING
BEGDA = DATE1
endda = DATE2
TAB_MODE = ' '
IMPORTING
DAYS = DAYS1
C_WEEKS =
C_MONTHS = C_YEARS1
C_YEARS = C_YEARS1
WEEKS = WEEK1
MONTHS = MONTH1
YEARS = YEAR1.
D_MONTHS =
MONTH_TAB =
*
*WRITE : / 'DAYS = ', DAYS1,
/ 'WEEKS = ',WEEK1,
/ 'MONTHS = ', MONTH1,
/ 'YEARS = ', YEAR1.
Using this code you can calculate the No Of Days Between two dates. Based On days you will easily calculate the Hour. No of days * 24 .
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |