Time difference

[system]

Hi Experts,
I have Webi XIr3.
I have Zulu time and local time.
Now I want calculate the offset (time difference b/w local and zulu time).
Any suggestions on how to calculate this in BO?

01/01/2010 9:55:00 - 01/01/2010 4:55:00 = 5

Appreciat your help.

---

Kalyani (BOB member since 2007-02-26)

[system]

Hi,

This 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)