BusinessObjects Board

Time Between Submit date and Completed Date

building reports webintelligence
#1

I have to informations, the submited date and the completed date. Is there a way to show how much time passed

for example

Submit date: 6/01/2012 12:10:14 AM
Completed date: 6/1/2012 12:25:13 AM

and make the result show
DD/MM/YYYY HH:MM:SS

Thanks

lherling (BOB member since 2013-04-05)

#2

Hi,

Have you tried using the WebI’s DaysBetween() function?

And welcome to B:bob:B!

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

#3

The DaysBetween() function doesn’t work on this object

A error message appears

“The expression or sub-expression at position 13 in the ‘DaysBetween’ function uses an invalid data type. (WIS 10037)”

Thanks

lherling (BOB member since 2013-04-05)

#4

Then try the formula from this topic:

The formula uses DeskI syntax so you will need to re-write it to WebI syntax. But that should not be a problem.

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

#5

I’ve tried to use the solution you suggested on the other post but a error message shows up

“The expression or sub-expression at position 13 in the ‘DaysBetween’ function uses an invalid data type. (WIS 10037)”

the formula is like this

“=DaysBetween([Submit Date Datetime] ;[Completed Date Datetime]) * 86400 + ( ToNumber(FormatDate([Completed Date Datetime] ;“HH”)) * 3600 + ToNumber(Left(FormatDate([Completed Date Datetime] ;“mm:ss”) ;2)) * 60 + ToNumber(FormatDate([Completed Date Datetime] ;“ss”))) - (ToNumber(FormatDate([Submit Date Datetime] ;“HH”)) * 3600 + ToNumber(Left(FormatDate([Submit Date Datetime] ;“mm:ss”) ;2)) * 60 + ToNumber(FormatDate([Submit Date Datetime] ;“ss”)))”

Thanks

lherling (BOB member since 2013-04-05)

#6

Hi,

what is the type of [Completed Date Datetime] and [Submit Date Datetime] ? Test to see wheter it is Date or String.

rgoulart :brazil: (BOB member since 2011-08-21)

#7

It looks that the [Submit Date Datetime] object is not of a date type. Is it not a string that looks as a date/time?

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

#8

They are both “String” type :frowning:
Does that mean it can’t be done?

lherling (BOB member since 2013-04-05)

#9

No, you have to convert it to date, use the function ToDate([date];“MM/dd/yyyy”) and then use DaysBetween

rgoulart :brazil: (BOB member since 2011-08-21)