BusinessObjects Board

Date difference in minutes

Hello

I have two fields Date1 and Date2 along with timestamp

[Date1]----------------------------------[Date2]
12/29/2008 9:21:56 AM---------------12/29/2008 1:33:33 PM

I want to display the difference between above two dates in minutes.Can some one please let me know how to calculate this measure.
I have used the “daysbetween” fuction and it only returns the difference of days but I require the difference in minutes.

Rgds
Ab


biswalamar (BOB member since 2006-01-04)

Check this FAQ.


Jansi :india: (BOB member since 2008-05-12)

Hi,
diffnumberseconds = to_date(,‘HH:MI:SS’) - to_date(,‘HH:MI:SS’) you will get number of seconds to convert in minutes divide by 60.
you will get what you want. I hope this helps

Regards,
resarav


resarav (BOB member since 2008-07-23)

Hi biswalamar,

Here is a solution for DeskI:

Give it a read and it should not be a problem to convert formulas from DeskI’s functions to WebI’s ones.


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