DateDiff in Reporting services 2008

How do I subtract two DateTime value & get Hours & Minutes returned in reporting services 2008.
u2envy1Asked:
Who is Participating?
 
shorakConnect With a Mentor Commented:
Try the following expression:


=(datediff("n",date1,date2)/60) & ":" & (datediff("n",date1,date2) mod 60)

should give you hours and minutes in the format hh:mm

Rob
0
 
u2envy1Author Commented:
Thx, it worked perfectly.....
0
All Courses

From novice to tech pro — start learning today.