days between does not take into consideration time stamp

[system]

I am using Business Objects report to calculate days between for a date in database with time stamp and current date.

For example :-

7/16/09 15:54:00-------------- 8/12/09 13:02:35(current date) is 27 days

The same when did in crystal reports using print date

7/16/09 15:54:00-------------- 8/12/09 13:02:35(print date) gives 26days

How can i calculate days between correctly in BO reports so that it also takes time stamp into consideration.

Thanks,
–h

---

hourigan (BOB member since 2007-04-06)

[system]

Hi,

Check this old topic if it helps:

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)

There is described a way how to get the difference between 2 dates down to seconds level.

---

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