topic need fm or code in Application Development and Automation Discussions

need fm or code

Former Member — Sat, 24 Feb 2007 10:39:32 GMT

Hi All,

i have two dates Date1 and Date2.

Now i want the difference between these two dates in days.

How can i get it.

Thanks a lot

Re: need fm or code

Former Member — Sat, 24 Feb 2007 10:43:33 GMT

chk this from other thread

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: need fm or code

Former Member — Sat, 24 Feb 2007 10:49:35 GMT

data : d1 like sy-datum value '20070201',

d2 like sy-datum value '20070204',

days type i.

days = d2 - d1.

write : / days.

or use fm

DAYS_BETWEEN_TWO_DATES

regards

shiba dutta

Re: need fm or code

Former Member — Sat, 24 Feb 2007 10:50:05 GMT

Hi ,

Use the function module

RP_DAYS_INTERVAL something like this try to search .it starts with

also use SD_DATETIME_DIFFERENCE

Please reward if useful

Re: need fm or code

Former Member — Sat, 24 Feb 2007 11:02:37 GMT

<b>PARAMETERS: DATE1 LIKE VTBBEWE-DBERVON,

DATE2 LIKE VTBBEWE-DBERBIS.

DATA: DDAYS LIKE VTBBEWE-ATAGE.

DMONTHS LIKE VTBBEWE-ATAGE,
DYEARS LIKE VTBBEWE-ATAGE.

call function 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

exporting

i_date_from = DATE1

i_date_to = DATE2

I_FLG_SEPARATE = ' '

IMPORTING

E_DAYS = DDAYS .

E_MONTHS = DMONTHS
E_YEARS = DYEARS.

WRITE:/ 'Difference in Days ', DDAYS.

</b>

Re: need fm or code

anversha_s — Sat, 24 Feb 2007 11:07:16 GMT

hi,

data: dat1 type sy-datum.
data: dat2 type sy-datum.
data: days like P0347-SCRDD.
 
dat1 = '20051212'.
 
dat2 = '20061212'.
 
 
CALL FUNCTION 'HR_HK_DIFF_BT_2_DATES'
  EXPORTING
    DATE1                         = dat2
    DATE2                         = dat1
   OUTPUT_FORMAT                 = '02'
 IMPORTING
 
  DAYS                          = days          .
 
 
Write:/ days.

Regards

Anver