date operations

[Former Member]

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,

[RichHeilman]

Sure, use function module RE_ADD_MONTH_TO_DATE

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

Regards,

RIch Heilman

[RichHeilman]

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

[ferry_lianto]

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

[Former Member]

Thanks a lot guys !!