Subracting Date/Time

[system]

I’m trying to subtract two date/Time fields. I need to know the duration in minutes between tow date/times.

I’ve tried daybetween and it only returns the difference in days not day/time.

I’ve also tried the simple formula of =date/time1-date/time2 and it is an invalid formula

Both date/time fields contain date such as: July 4 2009 1:34 PM

---

johnmartin (BOB member since 2009-08-11)

[system]

Welcome to B:bob:B!

I hope this topic will 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)