Elapsed time between 2 ddt fields

[system]

I have 2 date/time fields. I am trying to calculate the time difference in the 2. I pull data using BOXI webi from a McKesson clinical information system database. I would think there would be an easy way to build a variable but it is beyond me.
Thanks

---

sbiltd (BOB member since 2010-11-15)

[system]

Welcome to B:bob:B!

This can help:

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)