topic Re: Date calculation in Application Development and Automation Discussions

Date calculation

Former Member — Mon, 03 May 2004 14:21:41 GMT

Hello,

I want to calculate a new date (p.e. today + 3 months = 90 days)? I've tried to do this with the convert date and convert inverted-date, but the result was, that I ended with a date that was wrong (p.e. 43.04.2004).

Can someone help me?

Kind Regards,

S. Thomas

Re: Date calculation

Former Member — Mon, 03 May 2004 17:43:32 GMT

Hi Sylvie.

If you want to add 90 days.

Just do t1 = sy-datum + 90.

The system will automatically take care of the addition.

But if you want to add 3 months, then I would say you put in your piece of code.

a. Fetch the month component

b. add 3 to month component

c. if month component greater than 12 then month = month -12.

d. year = year + 1.

Pavan

Re: Date calculation

Former Member — Tue, 04 May 2004 13:33:06 GMT

Check fm RP_CALC_DATE_IN_INTERVAL

I find it very useful.

Cheers.

Re: Date calculation

Former Member — Wed, 05 May 2004 04:19:22 GMT

Hi,

You can even check this function modules, it works fine.

Function Module Name:: ADD_TIME_TO_DATE

Short Description :: Adds months/days/years to date.

Entering a negative value will subtract from the date.

Parameters ::

Exporting:

I_IDATE : Initial date

I_TIME : Quantity to add

I_IPRKZ : Unit of time(D:day, M:month, W:week, Y:year)

Importing:

O_IDATE : OUTPUT DATE.

Message was edited by: Bharath Kumar B

Re: Date calculation

former_member182371 — Wed, 05 May 2004 22:01:28 GMT

To solve the problem use function module

DATE_CONV_EXT_TO_INT

Hope it works.

let me know if it´s the case.

Re: Date calculation

Former Member — Thu, 06 May 2004 09:32:14 GMT

The function module CALCULATE_DATE also adds/subtracts days and months to/from a date. The following website also demonstrates a number of ways to add days/months taking into account working and non working days if that is any use. http://www.sapdevelopment.co.uk/tips/date/datehome.htm

CALL FUNCTION 'CALCULATE_DATE'

EXPORTING

DAYS = '0'

months = '01'

start_date = p_date

IMPORTING

result_date = p_date.

Message was edited by: Mart