Date Diff with AM/PM

[system]

Hi -
I have to calculate difference between the dates in seconds. the dates are in AM/PMtimestamp in the webi report.

---

ks.reddy (BOB member since 2007-01-18)

[system]

Hi,

This old topic may 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)

The formulas there in the topic are for DeskI so you will need to modify them for WebI because WebI has slightly different syntax of some functions.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Thanks mark-
I was under the misconception that format of hours doesnt take in to consideration of AM/PM, but it does take in to consideration.

---

ks.reddy (BOB member since 2007-01-18)