topic Re: Function module for date difference calculation in Application Development and Automation Discussions

Function module for date difference calculation

Former Member — Tue, 14 Nov 2006 05:50:03 GMT

hi all,

we have a requirement to calculate the difference date.

for eg: we have a field "datecnt = 4" and "date1 = 14-1-2006(i.e today date)"

the requirement is to subract datecnt from date1 such that the resultant should

be date1-datecnt = 10-11-2006.

is there any readily available function module for the same.

Thanks in Advance,

Kishore Kumar Yerra.

Re: Function module for date difference calculation

Former Member — Tue, 14 Nov 2006 05:52:57 GMT

no need of function module for this...this can be done directly...take a vriable v1 like sy-datum.

now, V1 = date1 - datecnt......the value is stored in the V1 field...

V1 = 14/11/2006 - 4...So, V1 will have 10/11/2006.

Re: Function module for date difference calculation

Former Member — Tue, 14 Nov 2006 05:54:13 GMT

Hi,

Use CALCULATE_DATE

Regards,

Raghav

Re: Function module for date difference calculation

Former Member — Tue, 14 Nov 2006 05:55:03 GMT

hi kishore ,

just try this ..

data: v_date like sy-datum,
      v_dateold like sy-datum.

 v_date = sy-datum.

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'
  EXPORTING
    date            = v_date
    days            = 04
    months          = 00
   SIGNUM           = '-'
    years           = 00
 IMPORTING
   CALC_DATE       = v_dateold.


write:/'Current date',  v_date,
        'Old date   ', v_dateold.

regards,

vijay

Re: Function module for date difference calculation

former_member283648 — Tue, 14 Nov 2006 05:58:12 GMT

Hi,

Try this

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'

EXPORTING

date = 11/14/2006

days = 4

months = 0

signum = -

years = 0

IMPORTING

calc_date = result.

Make sure the sign is minus if u want to subtract and plus if u want to add. dont worry about months and years....

Re: Function module for date difference calculation

anversha_s — Tue, 14 Nov 2006 06:01:25 GMT

hi kishore

use this FM.

data : wa_date type sy-datum.
 
call function 'RP_CALC_DATE_IN_INTERVAL'
exporting
date = sy-datum
days = 04 --------------------> give ur required date
months = 0
years = 0
signum = '-'
importing
calc_date = wa_date.
 
write :/ wa_date. -> new minised date

Note

signum = '+' "

signum = '-' "

rgds

Anver

if hlped pls mark points

Re: Function module for date difference calculation

Former Member — Tue, 14 Nov 2006 06:15:19 GMT

i have given a exaple u can also simply execute and give l3 = <some number>

is is suitable for ur requirement.....

<>

data: l1 like sy-datum,

l2 like sy-datum,

l3 type i.

l2 = sy-datum.

l3 = 4.

l1 = l2 - l3.

write:/ l1 dd/mm/yyyy.

out put is: 10.11.2006

Regards,

Ramesh.

Re: Function module for date difference calculation

Former Member — Tue, 14 Nov 2006 06:41:21 GMT

Hi,

Use the function module

HR_HK_DIFF_BT_2_DATES

(HR-HK: Calculate the days, months and years between)

WDKAL_DATE_ADD_FKDAYS

To find out different between dates by considering factory calender.

Regards,

Irfan Hussain

Note: Do reward helpful answers.