topic Re: difference in date in Application Development and Automation Discussions

difference in date

Former Member — Thu, 15 Feb 2007 12:42:54 GMT

hi,

How to find the difference between two dates.

Re: difference in date

Former Member — Thu, 15 Feb 2007 12:43:41 GMT

Hello,

DATA: RESULT TYPE I.

RESULT = DATE1 - DATE2.

WRITE: RESULT.

Vasanth

Re: difference in date

Former Member — Thu, 15 Feb 2007 12:44:55 GMT

data : date1 type sy-datum,
         date1 type sy-datum,
         date1 type sy-datum.
 

 date = date1 - date2

Re: difference in date

Former Member — Thu, 15 Feb 2007 13:00:36 GMT

good

if you want to find out the difference between two dates than you have to find out wheather you want to check the whole date formate or only some part of the date,

than you have to split the contents of the both the date and than check them .

Thanks

mrutyun^

Re: difference in date

Former Member — Thu, 15 Feb 2007 13:04:53 GMT

CALL FUNCTION 'DAYS_BETWEEN_TWO_DATES' 
EXPORTING 
I_DATUM_BIS = x_faede-zfbdt 
I_DATUM_VON = p_fdat 
I_KZ_EXCL_VON = '0' 
I_KZ_INCL_BIS = '0' 
I_KZ_ULT_BIS = ' ' 
I_KZ_ULT_VON = ' ' 
I_STGMETH = '0' 
I_SZBMETH = '1' 
IMPORTING 
E_TAGE = dias_v. 
IF SY-SUBRC <> 0. 
ENDIF. 

donde: 

x_faede-zfbdt -> 20050915 
p_fdat -> 20050811

Hi,

<b>For years and months betwwwn two days:</b>


DATA:   EYEARS  LIKE VTBBEWE-ATAGE.
PARAMETERS: FROMDATE LIKE PREL-BEGDA,
                 TODATE   LIKE PREL-BEGDA DEFAULT SY-DATUM.

CALL FUNCTION 'COMPUTE_YEARS_BETWEEN_DATES'
  EXPORTING
    first_date                        = fromdate
*   MODIFY_INTERVAL                   = ' '
    second_date                       = todate
 IMPORTING
   YEARS_BETWEEN_DATES               =  EYEARS
* EXCEPTIONS
*   SEQUENCE_OF_DATES_NOT_VALID       = 1
*   OTHERS                            = 2
          .
IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
Write:/ eyears.


DATA:       EMONTHS LIKE VTBBEWE-ATAGE.
PARAMETERS: FROMDATE LIKE SY-DATUM,
            TODATE   LIKE SY-DATUM
 DEFAULT SY-DATUM.

CALL FUNCTION 'MONTHS_BETWEEN_TWO_DATES'
  EXPORTING
    i_datum_bis         = fromdate
    i_datum_von         = todate
*   I_KZ_INCL_BIS       = ' '
 IMPORTING
   E_MONATE            = emonths
          .
write:/ emonths
 
*

try this and let me know.

Re: difference in date

Former Member — Thu, 15 Feb 2007 13:09:04 GMT

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.