BusinessObjects Board

hours or minutes between 2 date objects

building reports webintelligence
#1

I have 2 date/time objects. Open Date & Close Date. I would like to show the number of minutes in 1 variable and the number of hours in another variable. Anyone have suggestions?

THANKS!

hoopfmh (BOB member since 2012-06-18)

calculate the hours or minutes between 2 date/time fields
#2

Welcome to B:bob:B! Please read Marek’s suggestion here.

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

#3

Nope…This does not help me…

In Crystal i would use the Datediff function to get it to return number of minutes or Hours… OR I would just do the following: {Close Date/Time}-{Open Date/Time} * 60 * 24 This does not work in WEBI.

hoopfmh (BOB member since 2012-06-18)

#4

Anyone have any suggestions?

hoopfmh (BOB member since 2012-06-18)

#5

Hi,

This old topic can get you started:

The formulas there are for DeskI, should not be a problem to convert the syntax for WebI.

Let us know if you made it working or you need a further help.

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