topic Re: FUNCTION MODULE TO ADD MONTHS TO A DATE in Application Development and Automation Discussions

FUNCTION MODULE TO ADD MONTHS TO A DATE

former_member632991 — Mon, 29 Jan 2007 14:01:07 GMT

what is the function module to add months to a date.

i am using HR_PSD_DATES_ADD_MONTHS .

but if i am passing 31.1.2008 and adding 12 months then it is giving

31.1.2009 but it shud give 30.1.2009

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:03:40 GMT

Hi sonika,

1. u can also use HR_JP_ADD_MONTH_TO_DATE

2. Normally

3. 31.01.2008 + 1 year

31.01.2009

4. But, if u want 30.01.2009,

then u can simply

date = date - 1.

(where date contains the calcualted figure of 31.01.2009)

regards,

amit m.

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:04:48 GMT

Hi sonika,

use any of the following fms to add months to date..

u just have to pass two parameters..the months to be aDDED AND THE DATE

BKK_ADD_MONTH_TO_DATE

/BEV3/CHPS__ADD_MONTH_TO_DATE

with regards,

all the best,

sampath

*award if helpful and close the thread

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:05:33 GMT

Hi Sonika,

Run the below code to get u r result

Report zex33.

parameter : p_date(10),

p_months like T5A4A-DLYMO.

data : p_format type XUDATFM value 1,

date type datum,

v_dates like sy-datum.

CALL FUNCTION 'DATE_STRING_CONVERT'

EXPORTING

DATE_FORMAT = p_format

DATE_STRING = p_date

START_DATE = SY-DATUM

IMPORTING

RESULT_DATE = date.

call function 'RP_CALC_DATE_IN_INTERVAL'

exporting

date = date

days = 0

months = p_months

signum = '+'

years = 0

importing

calc_date = v_dates.

write : / v_dates.

give input as

p_date : 31.01.2008

p_months : 12

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:07:15 GMT

try this

RE_ADD_MONTH_TO_DATE

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:07:58 GMT

try this

RE_ADD_MONTH_TO_DATE

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:11:12 GMT

Hi,

I hope one of the following FM's will solve your problem.

RP_CALC_DATE_IN_INTERVAL : Add/subtract years/months/days from a date

MONTH_PLUS_DETERMINE : Add or subtract months from a date. To subtract a month, enter a negative value for the 'months' parameter.

RE_ADD_MONTH_TO_DATE : Can add/subtract months to/from date.

Reward points if the answer is helpful.

Regards,

Mukul

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:23:55 GMT

would you please be so nice to explain to me brainless bugger why you intend to get the 30.01.2009?

in my eyes the 31.01.2009 is quite fine.

12 month = 1 year = 365 days. since it´s 2008 we´re talking about it´s even 366 days (29 days february).

maybe thats why you get the 31.01.2009?

what is the difference between adding 12 month and a year?

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:26:43 GMT

Hi Florian,

YOu are spot on. She might have got confused with the leap year thingie.

Regards,

ravi

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Mon, 29 Jan 2007 14:38:13 GMT

use the FM RP_CALC_DATE_IN_INTERVAL

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

former_member632991 — Fri, 21 Jan 2011 07:58:58 GMT

Re: FUNCTION MODULE TO ADD MONTHS TO A DATE

Former Member — Fri, 23 Sep 2016 07:25:32 GMT

Hi Sonika,

Please Refer below Link

Regards,

Pritesh Raut