topic Re: calculating months in Application Development and Automation Discussions

calculating months

Former Member — Wed, 06 Feb 2008 06:13:48 GMT

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

Re: calculating months

Former Member — Wed, 06 Feb 2008 06:16:11 GMT

u can use function module

MONTHS_BETWEEN_TWO_DATES

Re: calculating months

Former Member — Wed, 06 Feb 2008 06:17:02 GMT

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

Re: calculating months

Former Member — Wed, 06 Feb 2008 06:17:28 GMT

Hi,

Use the FM:

MONTHS_BETWEEN_TWO_DATES

Regards,

Sowmya.

Re: calculating months

Former Member — Wed, 06 Feb 2008 06:18:53 GMT

Use F.M. HR_HK_DIFF_BT_2_DATES

Re: calculating months

Former Member — Wed, 06 Feb 2008 06:22:21 GMT

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 .