topic Function module for date in Application Development and Automation Discussions

Function module for date

Former Member — Fri, 08 Dec 2006 09:04:20 GMT

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.

Re: Function module for date

Former Member — Fri, 08 Dec 2006 09:07:44 GMT

Hi,

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

Regards

Bhupal Reddy

Re: Function module for date

Former Member — Fri, 08 Dec 2006 09:09:52 GMT

I solved it my self..

CCM_GO_BACK_MONTHS

Thanks for ur answers..

Re: Function module for date

Former Member — Fri, 08 Dec 2006 09:10:13 GMT

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

Re: Function module for date

Former Member — Fri, 08 Dec 2006 09:10:48 GMT

Hi,

You can use :

RE_ADD_MONTH_TO_DATE

Enable to ADD / Substract month to date.

Erwan

Re: Function module for date

Former Member — Fri, 08 Dec 2006 09:10:56 GMT

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

Re: Function module for date

Former Member — Fri, 08 Dec 2006 09:11:45 GMT

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

Re: Function module for date

Former Member — Fri, 08 Dec 2006 09:12:06 GMT

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.