topic Re: Function module required to subtract month from a date in Application Development and Automation Discussions

Function module required to subtract month from a date

Former Member — Thu, 24 May 2007 07:00:01 GMT

I have a date field..

In that I want to subtract some months..

Date1 = 27.05.2007

Month = 3 months

Date2 = 27.02.2007

Help me to proceed this logic with function module.

...What is the function module to get this liogic.

Re: Function module required to subtract month from a date

Former Member — Thu, 24 May 2007 07:01:49 GMT

Hi,

I don't think any FM available for your purposes.

But you can try something like this.

DATA: BEGIN OF ITAB OCCURS 0,

SPMON TYPE UMC_Y_VALIDFR,

END OF ITAB.

PARAMETERS PSPMON TYPE UMC_Y_VALIDFR DEFAULT '2007004'.

START-OF-SELECTION.

ITAB-SPMON = PSPMON.

DO 12 TIMES.

IF ITAB-SPMON+4(3) = '000'.

ITAB-SPMON+4(3) = '012'.

ITAB-SPMON(4) = ITAB-SPMON(4) - 1.

ENDIF.

APPEND ITAB.

ITAB-SPMON = ITAB-SPMON - 1.

ENDDO.

READ TABLE ITAB INDEX 12.

WRITE: / ITAB-SPMON.

Kishi.

Re: Function module required to subtract month from a date

Former Member — Thu, 24 May 2007 07:02:05 GMT

chk this

<b>RP_CALC_DATE_IN_INTERVAL</b>

Re: Function module required to subtract month from a date

Former Member — Thu, 24 May 2007 07:03:21 GMT

HR_PT_ADD_MONTH_TO_DATE

Re: Function module required to subtract month from a date

Former Member — Thu, 24 May 2007 07:03:41 GMT

I have got the solution

Re: Function module required to subtract month from a date

Former Member — Thu, 24 May 2007 07:03:43 GMT

hi,

USE fm CCM_GO_BACK_MONTHS

Thanks

Sandeep

Reward if helpful

Re: Function module required to subtract month from a date

Former Member — Thu, 24 May 2007 07:04:31 GMT

also chk this

REPORT abc MESSAGE-ID zz.

DATA : currdate LIKE sy-datum,
       backmonths(3) TYPE n,
       newdate LIKE sy-datum.

currdate = sy-datum.
backmonths = '3'.

CALL FUNCTION 'CCM_GO_BACK_MONTHS'
  EXPORTING
    currdate   = currdate
    backmonths = backmonths
  IMPORTING
    newdate    = newdate.


WRITE : newdate.

Re: Function module required to subtract month from a date

Former Member — Thu, 24 May 2007 07:04:34 GMT

Hi!

Use this Function Module

MONTHS_BETWEEN_TWO_DATES : To get the number of months between the two dates.

Subtract the months u want ..........

regards........

Re: Function module required to subtract month from a date

Former Member — Fri, 16 Nov 2007 12:40:17 GMT

even by that you can extract the value required.

You can also use one more function module OIL_DATE_SUBTRACT_MONTH.

Re: Function module required to subtract month from a date

Former Member — Mon, 08 Feb 2016 15:05:50 GMT

This function works for this cenario.