topic Re: Difference between two dates and time in hours in Application Development and Automation Discussions

Difference between two dates and time in hours

chetan_mishra — Fri, 16 Dec 2011 06:08:01 GMT

Hi,

I have fields contains start date, start time, end date, end time.

How do I calculate the number of hours since start date, start time and end date, end time

Start date : T_DATE1

Start time : T_TIME1

End Date : T_DATE2

End Time : T_TIME2.

Please help

Moderator Message: Date and Time questions are not allowed in this forum. The reason being they have been asked and answered many times here. Please search for relevant information here.

Edited by: kishan P on Dec 16, 2011 12:02 PM

Re: Difference between two dates and time in hours

mithun_shetty4 — Fri, 16 Dec 2011 06:19:10 GMT

SD_CALC_DURATION_FROM_DATETIME

SD_DATETIME_DIFFERENCE

Re: Difference between two dates and time in hours

Former Member — Fri, 16 Dec 2011 06:30:49 GMT

Hi,

Please find the FM - DELTA_TIME_DAY_HOUR,

this will give you the time in minutes, hence you can convert it to hours.

Please note the below links;

Moderator Message: Link-farm removed. Please dont do that again.

Hope you will search SDN next time, before posting.

And too hope that this will help you

Thanks & Regards

Manu S

Edited by: kishan P on Dec 16, 2011 12:03 PM