Number of Hours calculation

[system]

Hi,

Can anyone please let me know, how to calculate the time difference in Hrs from two dates in webi XI R2/R3.

For example, if we have two date fields like Start date and End date.
Start Date: 08/19/2010 10:15:05
End Date: 08/19/2010 11:15:05

How can i calculate the difference in these two dates in Hrs. I guess Days between function wont work here.

Thanks…

---

sumanreddy (BOB member since 2008-08-05)

[system]

In universe create two objects for hours

Hours1 to_number(TO_CHAR(DATE1,‘HH’))
Hours2 to_number(TO_CHAR(DATE2,‘HH’))

---

patriot3029 (BOB member since 2006-12-08)

[system]

Hi,

This can get you started:

Diff between two dates

I am trying to create a variable in Desktop Intelligence XI that will give me the diff between two dates. I used “=DaysBetween(<Admit Date & Time> ,<Order Date & Time>)” and I get just days. Is there a way to get his broke down to hours, minutes and seconds? djohnson (BOB member since 2007-07-26)

---

Marek Chladny (BOB member since 2003-11-27)