BusinessObjects Board

Note completed within 8 hours


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.


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)


This old topic can get you started:

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

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

Thanks Marek!!! :smiley:

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

WaltsMusic (BOB member since 2012-11-16)

You’re welcome 8)

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