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?
Who is Participating?
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.

All Courses

From novice to tech pro — start learning today.