Link to home
Start Free TrialLog in
Avatar of goodmanro
goodmanroFlag for United States of America

asked on

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?
Avatar of edlunad
edlunad
Flag of United States of America image

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
Avatar of goodmanro

ASKER

Anyone have a more simplistic solution?
ASKER CERTIFIED SOLUTION
Avatar of mimran18
mimran18
Flag of United Arab Emirates image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This script was very helpful.  I modified it for the US calendar and it worked without error.