question

SQL_User321 avatar image
SQL_User321 asked

DateDiff to exclude weekends and holidays between 2 dates

I am having an issue trying to get my head wrapped around what I need.

I am building an SSRS report that I need to exclude weekends and holidays between 2 dates.

I use the following datediff function; but this does not take into account that I need to exclude weekends and holidays. Is there anyone online that has done this before?

= iif(Fields!QCP.Value = 1, DateDiff("d", Fields!RECEIVEDDATETIME.Value, fields!ENDTIMESTAMP.Value),"")


Thanks in advance for your help.

ssrs-2008-r2ssrs-2012ssrs subscription
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SQL_User321 avatar image SQL_User321 commented ·

I have found a solution to this issue.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.