Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4384
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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