Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

DateDiff Expression in SSRS / How to calculate working days?

Posted on 2011-09-12
5
Medium Priority
?
6,358 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
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

916 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