ich have to calculate the difference between two dates in the format dd.mm.yyyy 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.
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:
(BOB member since 2003-11-27)