Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

DateDiff Expression in SSRS / How to calculate working days?

Posted on 2011-09-12
5
Medium Priority
?
6,215 Views
Last Modified: 2014-08-20
I have the following expression in an SSRS report:

=IIF(DateDiff("d",Fields!OrderDate.Value, Now())>2,"Overdue",Fields!JobStatus.Value)

Open in new window


The current interval is set to "d" for day.  I am looking to find the difference in the number of working days.  I have tried "dw" and "w" but neither seem work.  Any thoughts?
0
Comment
Question by:goodmanro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 9

Expert Comment

by:edlunad
ID: 36526771
There is no direct way to do it, but you can try something like the expression on this thread...

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/f7c567be-468e-43ed-8248-f13f6f666a7e
0
 

Author Comment

by:goodmanro
ID: 36527084
Anyone have a more simplistic solution?
0
 
LVL 9

Accepted Solution

by:
mimran18 earned 500 total points
ID: 36527349
0
 

Author Closing Comment

by:goodmanro
ID: 36535989
This script was very helpful.  I modified it for the US calendar and it worked without error.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
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…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

688 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