BusinessObjects Board

Report Variable - parsing error???

building reports desktopintelligence
#1

Hello,

I created a report variable “Last case log Hours” with the formula…

 Last case log Hours =(<Current Date> - <Last case note date>)*24

When I tried to parse this, I get error message…" incorrect data type". I tried to convert it to number /char… didn’t work.

Note: Last case note date & Current date are universe objects…
Last case note date = Max(caselog created date) & Current date is an object with sysdate value.

Am I missing something here?. Shed some light please…

Thanks
Subash S

subashs (BOB member since 2002-08-16)

#2

The result of your subtracting one date from another is a date, right? So what is, say 01/01/2004 multiplied by 24? It doesn’t make sense. The 24 indicates perhaps you are more interested in the time portion of the date?

Nick Daniels :uk: (BOB member since 2002-08-15)

#3

Nick,

Right…Basically I need to get the number of hrs(time)

Subash S

subashs (BOB member since 2002-08-16)

#4

A) Look at the Reporter function: DaysBetween( ,)

B) Business Objects Reporter does not offer a built-in calculation for Time Difference.

Please, try a search on BOB in the Reporter forum, suggested keywords: time difference hours
Author: Dave Rathbun

Or look in here in the BOB’s Download Forum.

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