Please help!! I am trying to get this formula to convert to dd:hh:mm

datediff("h", {Problem_Management.Date Opened},{Problem_Management.Date n Time Resolved by})

Right now it only converts to hours I need Days:hours:minutes

All suggestions are welcome.

DateDiff returns the difference between two dates. I cannot find a way to return Days:hours:minutes.

Hi
Had a similar issue!
Heres how I cracked it...
Number of Days
DATEDIFF(hh, FirstDate, SecondDate)/ 24 AS NoDays,
Number of Hours
0 - (DATEDIFF(hh, FirstDate, SecondDate) / 24 * 24 - DATEDIFF(hh, FirstDate, SecondDate)) AS NoHrs,
Number of Minutes
0 - (DATEDIFF(minute, FirstDate, SecondDate) / 60 * 60 - DATEDIFF(minute, FirstDate, SecondDate)) AS NoMins

Hope this helps ;)

Further to this I have included the code required to build a view using the Day,Hr,Min formula. And for smartness puts in the Colons.

SELECT FirstDate, SecondDate, CONVERT(Varchar, DATEDIFF(hh, FirstDate, SecondDate) / 24) + ':' + CONVERT(Varchar, 0 - (DATEDIFF(hh, FirstDate, SecondDate) / 24 * 24 - DATEDIFF(hh, FirstDate,
           SecondDate))) + ':' + CONVERT(Varchar, 0 - (DATEDIFF(minute, FirstDate, SecondDate) / 60 * 60 - DATEDIFF(minute, FirstDate, SecondDate))) AS NoDaysHrsMins
FROM Database.Table

As you can guess just change the tablename to your table & replace the FirstDate,SecondDate with your date fields.

Messy but I can see no other way of doing this.