Date and Time Issue

[system]

If I have a date and time filed in BO, How can I find the difference in the number of hours using standard functionality in BO?

I have a field in the following format: “12/30/2008 12:01:00 AM”

If I have another field: 12/31/2009 2:01:00 AM what is the way to tell the difference in the date and time in number of hours or days and hours?

---

welbonr (BOB member since 2009-11-23)

[system]

opps…

It should have been 12/31/2008 2:01:00 AM

---

welbonr (BOB member since 2009-11-23)

[system]

Hi,

This old topic should 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 formulas in the topic are for DeskI but it should not be a problem to convert them into formulas for WebI.

---

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