topic Re: date operations in Application Development and Automation Discussions

date operations

Former Member — Tue, 12 Jun 2007 17:51:44 GMT

Hy guys,

I have a date type variable, is there any function or a way to sum or substract months, days ??

I need to substract, 3, 6 and 12 months to a given date.

Thanks,

Re: date operations

RichHeilman — Tue, 12 Jun 2007 17:57:17 GMT

Sure, use function module RE_ADD_MONTH_TO_DATE

You can pass the parameter with a positive or negative value.

Regards,

RIch Heilman

Re: date operations

RichHeilman — Tue, 12 Jun 2007 18:03:21 GMT

Here is an example.



report zrich_0001 .

data: months type i.
data: new_date type sy-datum.

write:/ sy-datum.
do  3 times.

  months = abs( months - 3 ) * -1.
  call function 'RE_ADD_MONTH_TO_DATE'
       exporting
            months  = months
            olddate = sy-datum
       importing
            newdate = new_date.
  write:/ new_date.
enddo.

Regards,

Rich Heilman

Re: date operations

ferry_lianto — Tue, 12 Jun 2007 18:29:43 GMT

Hi,

Please try this FM RP_CALC_DATE_IN_INTERVAL.


data: wa_date like sy-datum.

call function 'RP_CALC_DATE_IN_INTERVAL'
  exporting
    date      = sy-datum
    days      =  0
    months    = 3
    signum    = '-'
    years     = 0
  importing
    calc_date = wa_date.

write: / wa_date.

Regards,

Ferry Lianto

Re: date operations

Former Member — Tue, 12 Jun 2007 20:11:34 GMT

Thanks a lot guys !!