• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7049
  • Last Modified:

DateDiff Expression in SSRS / How to calculate working days?

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?
1 Solution
There is no direct way to do it, but you can try something like the expression on this thread...

goodmanroAuthor Commented:
Anyone have a more simplistic solution?
goodmanroAuthor Commented:
This script was very helpful.  I modified it for the US calendar and it worked without error.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now