Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

calculating months

Former Member
0 Likes
789

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
758

hi

u can use function module

MONTHS_BETWEEN_TWO_DATES

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

5 REPLIES 5
Read only

Former Member
0 Likes
759

hi

u can use function module

MONTHS_BETWEEN_TWO_DATES

Read only

Former Member
0 Likes
758

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

Read only

Former Member
0 Likes
758

Hi,

Use the FM:

MONTHS_BETWEEN_TWO_DATES

Regards,

Sowmya.

Read only

Former Member
0 Likes
758

Use F.M. HR_HK_DIFF_BT_2_DATES

Read only

Former Member
0 Likes
758

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 .