BusinessObjects Board

days between does not take into consideration time stamp

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.


hourigan (BOB member since 2007-04-06)


Check this old topic if it helps:

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

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