topic Re: Date and Time Calculation in Application Development and Automation Discussions

Date and Time Calculation

Former Member — Wed, 19 Apr 2006 09:22:25 GMT

Dear all.

I need a function that receives a Date / Time and another Date and calculates the the sum of those values.

Best Regards,

Thanks In advanced.

PMR

Re: Date and Time Calculation

Former Member — Wed, 19 Apr 2006 09:25:53 GMT

Sum of two dates makes no sense.

Is it a sum of a date and number of days?

Then do like this.

v_new_date = v_date + no_of_days.

If you still want the sum of two dates,

just add them up and see what happens.

v_new_date = v_date1 + v_date2.

Regards,

Ravi

Re: Date and Time Calculation

Former Member — Wed, 19 Apr 2006 09:27:44 GMT

Hi Pedro,

PLease try out this function module...

RE_ADD_MONTH_TO_DATE

Please reward points if the answer was useful.

Regards,

Kunal

Re: Date and Time Calculation

Former Member — Wed, 19 Apr 2006 09:32:23 GMT

Hai Rodrigues,

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.

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

Regards,

Srikanth.

Re: Date and Time Calculation

Former Member — Wed, 19 Apr 2006 09:34:46 GMT

Dear All.

Update my Inquiry.

I need a function that receives a Date / Time and another time and calculates the the sum of those values.

Best Regards.

Thanks in Advanced

PMR

Re: Date and Time Calculation

Former Member — Wed, 19 Apr 2006 09:38:11 GMT

HI,

Will ADD_TIME_TO_DATE help?

Regards,

Gayathri

Re: Date and Time Calculation

Former Member — Wed, 19 Apr 2006 09:54:34 GMT

Dear all.

New update, Thanks for all helpfull replay's.

I need to pass the following Informations:

Import:

Date_1 (MM.DD.AAAA)

TIME_1 (HH:MM:SS)

Durations (HH:MM:SS)

Export:

Date_Result (MM.DD.AAAA)

Time_Result (HH:MM:SS)

The result off this funtions (If exist in the Standard) should be exemple:

Date_1 18.04.2006

Time_1 23:45:56

Durations 02:00:00

The result of the function must be

Date_Result 19.04.2006

Time_result 01:45:56.

Re: Date and Time Calculation

Former Member — Wed, 19 Apr 2006 10:01:01 GMT

Hai Rodrigues,

The program which i gave you works out for you,i suppose.

Just check out the earlier replies..

Regards,

Srikanth.

Re: Date and Time Calculation

Former Member — Wed, 19 Apr 2006 10:16:31 GMT

Hi Rodrigues,

Here is the Function Module that satisfies your requirement completely.

It is C14B_ADD_TIME.

Just check this code and try to give your own values.

data: a type sy-uzeit,

b type sy-datum,

c type sy-uzeit,

endtime type sy-uzeit,

enddate type sy-datum.

a = sy-uzeit.

b = sy-datum.

c = sy-uzeit.

CALL FUNCTION 'C14B_ADD_TIME'

EXPORTING

i_starttime = a

i_startdate = b

i_addtime = c

IMPORTING

E_ENDTIME = endtime

E_ENDDATE = enddate

write : endtime, enddate, a , c.

This will work.

Regards,

SP.