topic Re: Function Module to obtain date in Application Development and Automation Discussions

Function Module to obtain date

Former Member — Tue, 18 Jul 2006 06:48:51 GMT

Hi all

Can anyone suggest me the function module which satisfies below scenario:

Suppose i enter FROM date as :18.07.2006

and TO date as :20.07.2006

I should get number of days between these two dates as 1 and value :19.07.2006.

Thanks in advance

Regards

Neha Kapoor

Re: Function Module to obtain date

Former Member — Tue, 18 Jul 2006 06:51:27 GMT

Hi,

Check this function modules

"SD_DATETIME_DIFFERENCE"

"HR_HK_DIFF_BT_2_DATES"

Thanks and Regards,

Bharat Kumar Reddy.V

Message was Added by: Bharat Reddy V

Re: Function Module to obtain date

Former Member — Tue, 18 Jul 2006 06:53:45 GMT

Hi Neha,

Use this FM

HR_E_NUM_OF_DAYS_OF_MONTH (To get no.of days of the month)

Reward points if helpful.

Regards,

Harini

Re: Function Module to obtain date

Former Member — Tue, 18 Jul 2006 06:54:00 GMT

check this one .CSCP_PARA1_GET_PERIODS and Time uint is D.

Regards

Prabhu

Re: Function Module to obtain date

Former Member — Tue, 18 Jul 2006 06:56:08 GMT

Hi Neha,

You can use DAYS_BETWEEN_TWO_DATES FM to get the days between 2 dates.


PARAMETER:p_date1 TYPE dats,
          p_date2 TYPE dats.

DATA:lv_diff TYPE i,
     lv_no_date 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:/ 'Error'.
ELSE.
  WRITE:/ lv_diff.
ENDIF.

if lv_diff < 0.
lv_diff = lv_diff * -1.
endif.

lv_no_date = lv_diff - 1.

Reward if helpful

Rgds,

Re: Function Module to obtain date

Former Member — Tue, 18 Jul 2006 07:01:31 GMT

Hi neha,

1. just copy paste

2. It will list ALL THE DATES which fall in between,

and also the NUM OF DAYS.

report abc.

PARAMETERS : FROMDATE TYPE SY-DATUM DEFAULT '20060701'.

PARAMETERS : TODATE TYPE SY-DATUM DEFAULT SY-DATUM.

perform mydays using fromdate todate.

*----

FORM

*----

FORM MYDAYS USING MYFROMDATE MYTODATE.

DATA : CURDATE TYPE SY-DATUM.

DATA : NUMOFDAYS TYPE I.

CURDATE = MYFROMDATE + 1.

DO.

IF CURDATE >= MYTODATE.

EXIT.

ENDIF.

NUMOFDAYS = NUMOFDAYS + 1.

WRITE 😕 CURDATE.

CURDATE = CURDATE + 1.

ENDDO.

WRITE 😕 '------- Num of days ' , numofdays .

ENDFORM. "MYDAYS

regards,

amit m.

Re: Function Module to obtain date

Former Member — Tue, 18 Jul 2006 08:31:52 GMT

Hi,

declare the 2 dates that you have as DATS or type sy-datum. ( say d1 & d2 )

now declare a variable of type integer or NUMC. ( say n1 )

now n1 = d1 - d2...will give you the number of days between the 2 dates....

Re: Function Module to obtain date

Former Member — Tue, 18 Jul 2006 08:34:10 GMT

Hi,

declare the 2 dates that you have as DATS or type sy-datum. ( say d1 & d2 )

now declare a variable of type integer or NUMC. ( say n1 )

now n1 = d1 - d2...will give you the number of days between the 2 dates....hence n1-1 should give u the difference between the two dates, also d1 + ( n1 - 1 ) should give the desired date.

Thanks & Regards

Saikiran

Re: Function Module to obtain date

Former Member — Tue, 18 Jul 2006 08:35:57 GMT

hi,

CHeck FM DAYS_BETWEEN_TWO_DATES

http://www.sap-basis-abap.com/sapab015.htm

Re: Function Module to obtain date

Former Member — Mon, 24 Jul 2006 04:24:12 GMT

hi all

try this for finding difference between two dates.

data : temp type i.

data : d1 type sy-datum,

d2 type sy-datum.

d1 = '20060720'.

d2 = '20060718'.

temp = d1 - d2.

write : / temp.