Solved

DateDiff in Reporting services 2008

Posted on 2009-03-30
2
4,023 Views
Last Modified: 2012-05-06
How do I subtract two DateTime value & get Hours & Minutes returned in reporting services 2008.
0
Comment
Question by:u2envy1
2 Comments
 
LVL 11

Accepted Solution

by:
shorak earned 500 total points
ID: 24017877
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
 

Author Closing Comment

by:u2envy1
ID: 31564280
Thx, it worked perfectly.....
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now