topic Re: date diff in Application Development and Automation Discussions

date diff

Former Member — Tue, 21 Nov 2006 09:22:08 GMT

what is the program for to get diff between two dates.

Re: date diff

Former Member — Tue, 21 Nov 2006 09:23:44 GMT

U can just do x - y and it would give you the result in days.

ldate --->date1

ldays = ldate - sy-datum.

The above would give you the difference between two dates.

Re: date diff

anversha_s — Tue, 21 Nov 2006 09:24:12 GMT

hi,

just minus the 2 dates directly.

eg:

data: date1 type sy-datum,

date2 type sy-datum.

data: diff type i.

diff = date1 - date2.

regards

Anver

Re: date diff

Former Member — Tue, 21 Nov 2006 09:29:37 GMT

may i get it in following format

Ex: first date : 20006-11-20

second date: 20005-10-10

ans: 1-1-10

i want answer looikng like above.

Re: date diff

Former Member — Tue, 21 Nov 2006 09:31:18 GMT

Please check the following FM

SD_DATETIME_DIFFERENCE

Re: date diff

dani_mn — Tue, 21 Nov 2006 09:34:19 GMT

HI,

Try this FM.

HR_HK_DIFF_BT_2_DATES

Regards,

Re: date diff

Former Member — Tue, 21 Nov 2006 09:34:28 GMT

pls give code for it . i mean what i have to set.

Re: date diff

anversha_s — Tue, 21 Nov 2006 09:36:36 GMT

hi,

[code]

data: date1 type sy-datum,

date2 type sy-datum.

data: diff type i.

diff = date1 - date2.

then use FM

'CONVERT_DATE_TO_EXTERNAL'

data: datum(10) type c.

call function 'CONVERT_DATE_TO_EXTERNAL'

exporting

date_internal = diff

importing

date_external = datum.

write:/ datum.

[\code]

Regards

Anver

Message was edited by:

Anversha s

Re: date diff

Former Member — Tue, 21 Nov 2006 09:39:28 GMT

hi anver

pls give how to use that function

Re: date diff

Former Member — Tue, 21 Nov 2006 09:43:33 GMT

Hi Madhav,

Check this code.


  CALL FUNCTION 'HR_MX_INTERVAL_BETWEEN_DATES'
      EXPORTING
        I_DATE_START                = gd_start_date
        I_DATE_END                   = gd_end_date
      IMPORTING
        E_YEARS                       = gd_years
        E_DAYS                         = gd_days
      EXCEPTIONS
        SEQUENCE_OF_DATES_NOT_VALID = 1
        ERROR_IN_CALC_OF_YEARS      = 2
        NO_ENTRY_IN_T511K           = 3
        OTHERS                      = 4.
    if sy-subrc   <> 0.
    endif.

Hope this will help you.

Thanks & Regards,

Siri.

null

Re: date diff

dani_mn — Tue, 21 Nov 2006 09:43:57 GMT

HI,

check the example below

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,