BusinessObjects Board

Time difference between date between


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.

date difference.JPG

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

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


srinivas_bo :india: (BOB member since 2007-05-03)

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

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


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

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

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

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