BusinessObjects Board

Time difference between two dates

Hi guys,

ich have to calculate the difference between two dates in the format hh:mm:ss.

In database it worked and calculated the difference in days, like 0,0138888 days (which is 20 Munutes). but in WebI 3.1, it didn’t work. The formel is like: “=date2 - date1”. Both are dates with the same format in Universe designer.

Any idea why?

qklnnqkl (BOB member since 2014-02-19)


You can calculate the number of days between 2 dates in WebI using the DaysBetween(date1;date2) function.

If you need more precise result (hours, minutes, seconds) then the formula is more complicated, but feasible. Check for instance this old topic to get an idea:

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