Date Calculation Question

building reports webintelligence
1

Good afternoon,

I need some help calculating the time between two dates. What I want to do is be able to determine the minutes and hours between them. When trying to do a simple subtraction (when making a function), it tells me that I’m using invalid data types. The system does understand they are dates because I am able to use the built in DaysBetween() function. The problem is that there is no built in function that gives minutes or hours between two dates, and the value returned from DaysBetween() gives only whole numbers even when I format it to 2 decimal places.

I need to be able to make this calculation so that I can check the time between two date/time stamps to see if they fall within various SLA standards.

Also, I am using WebIntelligence Version 11.5.8.963

Thank you,

David

David Baer (BOB member since 2009-05-01)

2

Welecome to B :mrgreen: B
Try this solution - Topic
Easier soluton at the universe design

KhoushikTTT :us: (BOB member since 2005-02-24)