topic Re: Date differences in Application Development and Automation Discussions

Date differences

Former Member — Tue, 24 Apr 2007 06:35:38 GMT

Hi Experts,

Do we have any functional module to calculate date differences.~

Appreciate your response~

Thanks,

Hari

Re: Date differences

Former Member — Tue, 24 Apr 2007 06:37:29 GMT

check these

HR_HK_DIFF_BT_2_DATES".

SD_DATETIME_DIFFERENCE

Regards

Prabhu

Re: Date differences

Former Member — Tue, 24 Apr 2007 06:40:07 GMT

Hi Hari,

you may use (for example) function module HR_HK_DIFF_BT_2_DATES:


call function 'HR_HK_DIFF_BT_2_DATES'
  importing
    date1 = '20070424'
    date2 = '20020101'
    output_format = '03'
  exporting
    years = l_years
    months = l_months
    days = l_days.

will yield l_years = 5 and l_days = 114.

I hope it helps. BR,

Alvaro

Re: Date differences

Former Member — Tue, 24 Apr 2007 06:42:17 GMT

hi hari

fm is

DAYS_BETWEEN_TWO_DATES

MONTHS_BETWEEN_TWO_DATES

/SDF/CMO_DATETIME_DIFFERENCE

SD_DATETIME_DIFFERENCE

'HR_HK_DIFF_BT_2_DATES'

SD_DATETIME_DIFFERENCE Give the difference in Days and Time for 2 dates

CALL FUNCTION 'SD_DATETIME_DIFFERENCE' EXPORTING

DATE1 = p_zvttk-tndr_expd

TIME1 = p_zvttk-tndr_expt

DATE2 = sy-datlo

TIME2 = sy-timlo

IMPORTING

EARLIEST = earliest EXCEPTIONS

INVALID_DATETIME = 1

OTHERS = 2.

FM DAYS_BETWEEN_TWO_DATES

Ex:

PARAMETER:p_date1 TYPE dats,

p_date2 TYPE dats.

DATA:lv_diff TYPE i.

CALL FUNCTION 'DAYS_BETWEEN_TWO_DATES'

EXPORTING

i_datum_bis = p_date1

i_datum_von = p_date2

IMPORTING

e_tage = lv_diff

EXCEPTIONS

days_method_not_defined = 1

OTHERS = 2.

IF sy-subrc = 0.

WRITE:/ lv_diff.

ENDIF.

reagrds

navjot

reward if helpfull.....

Re: Date differences

Former Member — Tue, 24 Apr 2007 06:57:09 GMT

You can use the FM HR_HK_DIFF_BT_2_DATES for finding the date difference.

call function 'HR_HK_DIFF_BT_2_DATES'

exporting

date1 = i_final-udate

date2 = i_final-erdat

OUTPUT_FORMAT = '02'

IMPORTING

DAYS = i_final-no_of_days1.

i_final-no_of_days1 = i_final-no_of_days1 - 1 .

Thanks,

Maheshwari V

Re: Date differences

Former Member — Tue, 24 Apr 2007 06:58:07 GMT

use the FM HR_CALC_YEAR_MONTH_DAY