Date Diff with AM/PM

[system]

Hi,

This old topic may help:

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)

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)