topic problem in adding month to date in Application Development and Automation Discussions

problem in adding month to date

satish_kumar127 — Fri, 16 May 2014 14:29:14 GMT

Hi guru's,

actually my requirement is to add 1 month to input date which is having range (FROM DATE and TO DATE ).

lets say, my input is for From date is 01.04.2014 and TO Date is 30.04.2014.

and i'm expecting From Date is 01.05.2014 and TO Date is 31.05.2014 after adding month as may month contains 31 days.

in my report i have used "RE_ADD_MONTH_TO_DATE" function module. it's giving me TO date is 30.05.2014 .

could anybody please give me some idea .

Thanks in Advance.

Regards

satish

Re: problem in adding month to date

Former Member — Fri, 16 May 2014 14:38:08 GMT

Hi.

use this function

CALL FUNCTION 'MONTH_PLUS_DETERMINE'

EXPORTING

months = '1'

olddate = sy-datum

IMPORTING

NEWDATE = l_fecha .

Regards

Miguel

Re: problem in adding month to date

satish_kumar127 — Fri, 16 May 2014 14:49:48 GMT

hi miguel,

Thanks for ur prompt reply, but I've tried and failed to make this work.

As i've already mentioned in my query , given input is 30.04.2014 and it's giving me 30.05.2014

but i'm expecting 31.05.2014.

regards

satish

Re: problem in adding month to date

Former Member — Fri, 16 May 2014 14:54:18 GMT

you are asking for 1 month from the input date.

it sounds like what you are after is the last day of the month

several ways you can do this.....

one way....take the 1st day of a month and subtract 1 from it

or use one of the many date functions, like

FKK_GET_LAST_DAY_OF_MONTH for example....only need to supply the date in and last day is returned.

Re: problem in adding month to date

Former Member — Fri, 16 May 2014 14:54:48 GMT

so, what u need to do is to first count the days of the months, some months 30 or 31..then add those days to the date by normal add.

l_date1 = 01.04.2014

CALL FUNCTION 'NUMBER_OF_DAYS_PER_MONTH_GET'

EXPORTING

par_month = '05'

par_year = '2014'

IMPORTING

PAR_DAYS = l_dias .

l_date = l_date1 + l_days.

Regards

Miguel

Re: problem in adding month to date

Former Member — Fri, 16 May 2014 14:56:59 GMT

Hi,

add first 1 month than try FM: LAST_DAY_OF_MONTH-

regards, Dieter

Re: problem in adding month to date

satish_kumar127 — Fri, 16 May 2014 15:14:32 GMT

thank u all for your valuable time and helpful replies. problem solved.