Date/Time Difference?

[system]

This is a common subject. Here is a topic that discusses how to do this in Web Intelligence:

120×120 10.4 KB

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)

I usually use the =LastExecutionDate() instead of the CurrentDate() or Time functions. This way, the report will not change values until it is refreshed again.

If possible, it is better to create a universe object that tracks the difference between two dates.

---

Wlog (BOB member since 2012-07-26)