BusinessObjects Board

difference between two dates in hour minutes and seconds

scheduling Broadcast Agent (BCA)
#1

Hi,
I use two dates from SQL data provider in a report.
I want to calculate the difference between thoses date in seconds,minutes.
Has somebody already done this?
This is what I want :
DATE1 DATE2 DELTA
15/08/04 11:00:02 15/08/04/ 09:30:00 1(hour) 30 (minutes) 02(sec)
I can’t include the calculation in the data provider because the rules are define within the report
Thanks for help

kakounj (BOB member since 2004-05-14)

#2

If you are looking for a Reporter solution, check this thread.

Andreas :de: (BOB member since 2002-06-20)