topic Re: finding the function madule in Application Development and Automation Discussions

finding the function madule

Former Member — Tue, 19 Aug 2008 14:21:53 GMT

hi,

i want to know the function modules which give

1.no.days between two given dates

2.no.months between two given dates

3.no.years between two gives dates

thanks in advance.

Re: finding the function madule

Former Member — Tue, 19 Aug 2008 14:26:17 GMT

You may want to try and Search this Forum, as this has been asked several times. I did a Search on "Days Between" and found 103 hits.

Re: finding the function madule

Former Member — Tue, 19 Aug 2008 14:28:10 GMT

Kiran,

just give appropriate term in se37 with wild char and press F4 you will get many FM use either among them.

like daybetween* press F4 and all possible term.

Amit.

Re: finding the function madule

Former Member — Tue, 19 Aug 2008 17:38:48 GMT

Chk this FM.

FIMA_DAYS_AND_MONTHS_AND_YEARS

Re: finding the function madule

Former Member — Tue, 19 Aug 2008 17:51:14 GMT

MONTHS_BETWEEN_TWO_DATES : To get the number of months between the two dates.

HR_99S_INTERVAL_BETWEEN_DATES : Difference between two dates in days, weeks, months

RP_CALC_DATE_IN_INTERVAL

Add/subtract years/months/days from a date

Re: finding the function madule

Former Member — Wed, 20 Aug 2008 03:34:23 GMT

Hi kiran,

You can use the FM HR_GET_TIME_BETWEEN_DATES to get months,years and days between two dates.

Example:-

data :
w_days type p,
w_months type p,
w_years type p.

  CALL FUNCTION 'HR_GET_TIME_BETWEEN_DATES'
    EXPORTING
      beg_date       = fs_day-f_day
      end_date       = fs_day-l_day
    IMPORTING
      months         = w_months
      days             = w_days
      years            = w_years
    EXCEPTIONS
      invalid_period = 1
      OTHERS         = 2.

  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
       WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.                               " IF SY-SUBRC <> 0

This will definitely solve your issue.

Best of luck,

Bhumika

Re: finding the function madule

Former Member — Wed, 20 Aug 2008 08:17:06 GMT

This FM will give you all you need

HR_99S_INTERVAL_BETWEEN_DATES

Regards,

Prashant

Re: finding the function madule

Former Member — Wed, 20 Aug 2008 13:17:10 GMT

1) To get the number of months between the two dates.

use function mod

MONTHS_BETWEEN_TWO_DATES

2) To get the number of days between the two dates

Check the Fun Mod

SD_DATETIME_DIFFERENCE and

RP_CALC_DATE_IN_INTERVAL

3) To get the number of weeks between the two dates

check fun mod

HR_IE_NUM_PRSI_WEEKS

4) To get the number of years between the two dates

check fun mod

HR_HK_DIFF_BT_2_DATES

Regards

srinivas

Re: finding the function madule

Former Member — Tue, 26 Aug 2008 12:04:25 GMT

hi,

you can use these fm .

RP_CALC_DATE_IN_INTERVAL

HR_IE_NUM_PRSI_WEEKS

Re: finding the function madule

Subhankar — Wed, 27 Aug 2008 06:21:11 GMT

Hi..

Please use the FM HRCO_GET_TIME_BETWEEN_DATES ..

I think it will solve ur problems..

DATA: v_date1 TYPE sy-datum,

v_date2 TYPE sy-datum,

v_days TYPE P,

v_month TYPE p,

v_year TYPE p.

v_date1 = sy-datum.

v_date2 = '20100826'.

CALL FUNCTION 'HRCO_GET_TIME_BETWEEN_DATES'

EXPORTING

beg_date = v_date1

end_date = v_date2

IMPORTING

DAYS = v_days

MONTHS = v_month

YEARS = v_year

EXCEPTIONS

INVALID_PERIOD = 1

OTHERS = 2

IF sy-subrc = 0.

WRITE : / v_days, v_month, v_year.

ENDIF.

Re: finding the function madule

shadow — Wed, 27 Aug 2008 09:11:15 GMT

Hi ,

hope dis is use full for u..................

HR_GET_TIME_BETWEEN_DATES

HR_99S_INTERVAL_BETWEEN_DATES

Regard's

Shaik.

Re: finding the function madule

UmaArjunan — Wed, 27 Aug 2008 10:21:47 GMT

Run this report. This will exactly match your requirement.

I searched this from the net. copy the code and check in your system by giving two inputs start date and end date to calculated no of days,months and year

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.

Re: finding the function madule

Former Member — Wed, 27 Aug 2008 11:36:25 GMT

Hi Kiran,

Try this FM's:

SD_DATETIME_DIFFERENCE

Give the difference in Days and Time for 2 dates

HR_IE_NUM_PRSI_WEEKS

Return the number of weeks between two dates.

RP_CALC_DATE_IN_INTERVAL

Add/subtract years/months/days from a date

With luck,

Pritam.