goodmanro
asked on
DateDiff Expression in SSRS / How to calculate working days?
I have the following expression in an SSRS report:
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?
=IIF(DateDiff("d",Fields!OrderDate.Value, Now())>2,"Overdue",Fields!JobStatus.Value)
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?
ASKER
Anyone have a more simplistic solution?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This script was very helpful. I modified it for the US calendar and it worked without error.
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/f7c567be-468e-43ed-8248-f13f6f666a7e