Time difference between date between

[system]

Hi

I have requirement where i need to calculate date daiffrnce;

requirement is i have Id and reqs and date where as date as one column…, for one id’s i have number 2 req…,i want caluclate what is the time diffrnce between dates please find attached screenshot …, where last column i am expectng output.

I tryed with daybeetween and few more.

Thanks

---

pavan.au143 (BOB member since 2011-12-29)

[system]

Whis is the other date you want use for date diff.current Date?

Thanks,
Sri

---

srinivas_bo (BOB member since 2007-05-03)

[system]

Noo current data…, I want within the same date only

---

pavan.au143 (BOB member since 2011-12-29)

[system]

Hi,

So you actually need the difference between [Date] and Previous([Date])?

Use a technique (formulas) described in this old topic:

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)

By the way, the calculation in your picture is not correct. It should be 2:24:57

---

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