Solved

DateDiff in Reporting services 2008

Posted on 2009-03-30
2
4,047 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to setup a best practice sql maintenance plan Transaction logs full 6 76
SQL Upgrade 3 59
SSRS 2012 URL 11 62
How to Parameterize an update sql using a Pivot sql 7 49
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 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