system
May 24, 2012, 6:42am
#1
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
May 24, 2012, 7:22am
#2
Whis is the other date you want use for date diff.current Date?
Thanks,
Sri
srinivas_bo (BOB member since 2007-05-03)
system
May 24, 2012, 11:24am
#3
Noo current data…, I want within the same date only
pavan.au143 (BOB member since 2011-12-29)
system
May 24, 2012, 1:17pm
#4
Hi,
So you actually need the difference between [Date] and Previous([Date])?
Use a technique (formulas) described in this old topic:
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:2 4:57
Marek Chladny (BOB member since 2003-11-27)