[solved] calculate time between two dates

[system]

Hello,

I have two time fields, “start” and “end”, in the format “Jul 27, 2010 08:13:47”. I want to subtract the start from the end time to get the time difference between the two dates.

Is this something that can be done easily in WebIntelligence XI R2?
Thanks!

---

awayand (BOB member since 2010-10-12)

[system]

Welcome to B:bob:B!

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)

[system]

you are the best. thanks a million!

---

awayand (BOB member since 2010-10-12)