topic Re: Date Calculation in Application Development and Automation Discussions

Date Calculation

Former Member — Fri, 27 Apr 2007 13:08:02 GMT

Can somebody tell me as to how number of days can be calculated between given two dates??

I want the number of days , like between 20/04/2007 and 25/04/2007 the number of days are 6 days.

Re: Date Calculation

Former Member — Fri, 27 Apr 2007 13:09:29 GMT

simply use substraction

declare days as Type I.

days = date1 - date2.

reward points

regards

Anji

Re: Date Calculation

Former Member — Fri, 27 Apr 2007 13:09:55 GMT

I think just subtract the two and put the result in a integer field should do the trick !!

Re: Date Calculation

alex_m — Fri, 27 Apr 2007 13:11:17 GMT

Data day type i.

day = date1 - date2.

Re: Date Calculation

ferry_lianto — Fri, 27 Apr 2007 13:19:37 GMT

Hi,

Please use FM HR_HK_DIFF_BT_2_DATES.



DATA: L_DATE1 LIKE SY-DATUM VALUE '20040425',
      L_DATE2 LIKE SY-DATUM VALUE '20040420',
      L_DAYS  LIKE P0347-SCRDD.
                                                                        
CALL FUNCTION 'HR_HK_DIFF_BT_2_DATES'
  EXPORTING
    DATE1                   = L_DATE1
    DATE2                   = L_DATE2
    OUTPUT_FORMAT           = '03'
  IMPORTING
    DAYS                    = L_DAYS
  EXCEPTIONS
    INVALID_DATES_SPECIFIED = 1
    OTHERS                  = 2.
                                                                        
WRITE: / L_DAYS.

Regards,

Ferry Lianto

Re: Date Calculation

Former Member — Fri, 27 Apr 2007 13:55:13 GMT

data: days type i.

days = day_l - day_s.