Note completed within 8 hours

[system]

Greetings!!

I have a report that has 2 date/time stamp columns. The first is Admit Date (Patient Admitted) The second is Note Date (Admission assessment completed). What I need is a variable/alert to show the hours between the admission and the completion of the admission assessment, with the goal of Note Date being less than 8 hours. I have tried using DaysBetween but I need it in hours.

Using WEBI XI

Example:
Admit Date/Time - 1/6/13 1:44 PM
Note Date and Time - 1/6/13 5:20 PM

Any help is greatly appreciated!

---

WaltsMusic (BOB member since 2012-11-16)

[system]

Hi,

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)

The DeskI syntax of formulas will need to be converted to WebI syntax.

---

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

[system]

Thanks Marek!!!

That worked great! I can now do an alert for any note over 28880 seconds!

---

WaltsMusic (BOB member since 2012-11-16)

[system]

You’re welcome 8)

---

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