Function module for date calculation

[Former Member]

Hi all,

is there any function module which gives the exact date

for which the import is some date along with some days to be

added for the date to obtain the exact date.

ex:

12/28/2006 + 4 days = 1/01/2007

[Former Member]

EXECUTE THIS

data: date like sy-datum,

date1 like sy-datum.

date = sy-datum. " or pass ur date value here

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'

EXPORTING

date = date

days = 04 "days added

months = 00

SIGNUM = '+'

years = 00

IMPORTING

CALC_DATE = date1. " new date

write:/ 'new date', date1.

regards,

vijay

[Former Member]

use the FM

<u><b>RP_CALC_DATE_IN_INTERVAL</b></u>

Import parameters Value

DATE 12/28/2006

DAYS 04

MONTHS 00

SIGNUM +

YEARS 00

Export parameters Value

CALC_DATE 01/01/2007

Eswar Kanakanti

[Former Member]

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'

EXPORTING

DATE = SY-DATUM

DAYS = 00

MONTHS = 03

SIGNUM = '-'

YEARS = 00

IMPORTING

CALC_DATE = WA_AUDAT-LOW.

APPEND WA_AUDAT TO S_AUDAT.

[Former Member]

Well, the easiest thing to do is to simply add a number (of days) to a date.

data: w_date like sy-datum.
w_date = sy-datum.
w_date = w_date + 90.
* w_date has a date 90 days in the future.


But if you have to add months or years, you can use FM RP_CALC_DATE_IN_INTERVAL:

data: w_date like sy-datum.
data: new_date like sy-datum.
CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL' 
     EXPORTING                           
          DATE      = w_date   
          DAYS      = 0                  
          MONTHS    = 3                  
          SIGNUM    = '+'                
          YEARS     = 0                  
     IMPORTING                           
          CALC_DATE = new_date   
     EXCEPTIONS                          
          OTHERS    = 1.        

• new_date has a value 3 months in the future.

Regards,

Santosh

[Former Member]

Hi kiran,

<b>

RP_CALC_DATE_IN_INTERVAL</b> -

Add/subtract years/months/days from a date

data : v_dates like sy-datum.

call function 'RP_CALC_DATE_IN_INTERVAL'

exporting

date = sy-datum

days = 4

months = 0

signum = '+'

years = 0

importing

calc_date = v_dates.

(or)

<b>DATE_IN_FUTURE</b> -

Import: date in current external format for user; number of days.

Export: calculated date in future in external format mm/dd/yyyy

data : cur_date like sy-datum,

v_dates like sy-datum,

days type i value 4.

initialization.

cur_date = sy-datum.

CALL FUNCTION 'DATE_IN_FUTURE'

EXPORTING

anzahl_tage = days

import_datum = cur_date

IMPORTING

EXPORT_DATUM_INT_FORMAT = v_date.