system
#1
Hi,
Can anyone please let me know, how to calculate the time difference in Hrs from two dates in webi XI R2/R3.
For example, if we have two date fields like Start date and End date.
Start Date: 08/19/2010 10:15:05
End Date: 08/19/2010 11:15:05
How can i calculate the difference in these two dates in Hrs. I guess Days between function wont work here.
Thanks…
sumanreddy (BOB member since 2008-08-05)
system
#2
In universe create two objects for hours
Hours1 to_number(TO_CHAR(DATE1,‘HH’))
Hours2 to_number(TO_CHAR(DATE2,‘HH’))
patriot3029 (BOB member since 2006-12-08)
system
#3
Hi,
This can get you started:
Marek Chladny (BOB member since 2003-11-27)