Time Stamp Difference

[system]

Hi,

I need to find difference between 2 dates with time stamp.
I checked many post but did not find any solution to time stamp difference.

I do get timestamp by using FormatDate but using DaysBetween gives me Zero.

is there a way by which I can get time stamp difference as well?

date1: 01/02/03 04:05:06
date2: 03/05/07 09:11:13

Diff: 02/03/04 05:06:07

Please note I don’t have access to either Database or Universe. Need to do it in WebI only.

---

suruworks (BOB member since 2007-05-21)

[system]

Hi,

This 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)

---

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