compare hours using days between

[system]

I have to date objects and I need to get the hours between them [Performed Date/Time] ; [End Date/Time]

how can I do this?

Thanks

---

tonyreba77 (BOB member since 2010-09-18)

[system]

Hi,

Check this out:

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)

[system]

how do I say
= (((ToNumber(SubStr(FormatDate([Oral Care].[Clinical Event Performed Date/Time];“HH:mm:ss”) , 1 , 2 ) ) * 60 in WebI ???

---

tonyreba77 (BOB member since 2010-09-18)

[system]

If only the above piece of the code is not working in WebI for you then replace in the code “,” with “;”.

---

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