[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4330
  • Last Modified:

DateDiff in Reporting services 2008

How do I subtract two DateTime value & get Hours & Minutes returned in reporting services 2008.
0
u2envy1
Asked:
u2envy1
1 Solution
 
shorakCommented:
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now