Solved

DateDiff Expression in SSRS / How to calculate working days?

Posted on 2011-09-12
5
6,000 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 125 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

622 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