trying to set up a elapse time between two dates

[system]

I am trying to set up an elapse time between two different date/time fields. any help would be appreciated. Using BOXI

Thanks

---

monikasue (BOB member since 2011-11-01)

[system]

Hi,

You can use the Daysbetween([date1];[date2]) function which will give you the number of days between the [date1] and the [date2].

If you need the result be in the portions of days (hours, minutes, seconds) then this old topic 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)