topic Re: date function in Application Development and Automation Discussions

date function

Former Member — Tue, 03 Jun 2008 10:47:32 GMT

is there any function module which could comput difference between two dates specific to a factory calender.

Re: date function

Former Member — Tue, 03 Jun 2008 10:48:53 GMT

Function: DAYS_BETWEEN_TWO_DATES

Re: date function

Former Member — Tue, 03 Jun 2008 10:54:27 GMT

Hi,

U can use

RP_CALC_DATE_IN_INTERVAL

SD_DATETIME_DIFFERENCE

Thanks

Re: date function

Former Member — Tue, 03 Jun 2008 10:54:50 GMT

We use a combination of FMs

DATE_CONVERT_TO_FACTORYDATE

and

RKE_SELECT_FACTDAYS_FOR_PERIOD

Something like this is the final computation


* get range of working calendar dates
CALL FUNCTION 'RKE_SELECT_FACTDAYS_FOR_PERIOD'
  EXPORTING
    I_DATAB                     = request_date
    I_DATBI                     = action_date
    I_FACTID                    = 'US'
  TABLES
    ETH_DATS                    = wdates
 EXCEPTIONS
   DATE_CONVERSION_ERROR       = 1
   OTHERS                      = 2.


 IF SY-SUBRC <> 0.
   raise dates_error.
 ENDIF.


 LOOP at wdates.
  if wdates-periodat gt request_date.
   add 1 to days.
  endif.
 ENDLOOP.

 days_to_complete = days.