Incident Rule
Submitted by syarlett on 28 August, 2008 - 00:42.
Hi,
I have the query below which return a value in minutes. Is there a way i can get the result in DD:HH:MI (Days, Hours, Minutes) ?
workitem(workitem_comment)
[color=blue]-------------------------------------[/color]
Time to resolution=HDQUERY[[select DATEDIFF(mi,[workitem_created_on],[workitem_modified_on]) From [Workitem_Current_View] where workitem_number=WORKITEM(workitem_number)]] minutes
I've tried changing where it says MI to HH12:MI but that didnt work....




Recent comments
35 min 32 sec ago
4 hours 54 min ago
5 hours 15 min ago
5 hours 58 min ago
6 hours 46 min ago
6 hours 48 min ago
6 hours 51 min ago
7 hours 38 min ago
8 hours 2 min ago
9 hours 49 min ago