Function module for date

[Former Member]

Dear all,

Could any one help me for below requirement..

I need a FM in which input is Current date, Number of months.

Output should be the date before the Number of months.

eg.

Input: Sy-datum 08.12.2006

No.of months 13

output: 01.11.2006

Thanks in advance.

[Former Member]

Hi,

Use the FM MONTH_PLUS_DETERMINE . Please supplu negative values of months your requirement will be fullfilled.

Regards

Bhupal Reddy

[Former Member]

I solved it my self..

CCM_GO_BACK_MONTHS

Thanks for ur answers..

[Former Member]

Hi,

You can use :

RE_ADD_MONTH_TO_DATE

Enable to ADD / Substract month to date.

Erwan

[Former Member]

Hi,

try any of these

SG_PS_GET_LAST_DAY_OF_MONTH

RE_LAST_DAY_OF_MONTH

HR_HCP_GET_LAST_DAY_OF_MONTH

HRVE_LAST_DAY_OF_MONTH

RP_LAST_DAY_OF_MONTHS

SLS_MISC_GET_LAST_DAY_OF_MONTH

LAST_DAY_OF_MONTHS

WSAF_GET_LAST_DAY_OF_MONTH

regards,

pankaj singh

[Former Member]

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

[Former Member]

Hi,

Use the FM MONTH_PLUS_DETERMINE . Please supplu negative values of months your requirement will be fullfilled.

After this FM

Input: Sy-datum 08.12.2006

No.of months 13

output: 08.11.2006

Please add the following statement.

lv_output+6(2) = '01'.

Your requirement will be fullfilled.

Regards

Bhupal Reddy

[Former Member]

Hi Matt,

check this

REPORT YCHATEST LINE-SIZE 350.

DATA : V_DATE LIKE SY-DATUM.

CALL FUNCTION 'MONTH_PLUS_DETERMINE'
  EXPORTING
    MONTHS  = '-13'
    OLDDATE = SY-DATUM
  IMPORTING
    NEWDATE = V_DATE.

WRITE : / V_DATE.