Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Count only Weekdays

Author  Topic 

tech2
Yak Posting Veteran

51 Posts

Posted - 2014-11-06 : 14:35:50
Trying to count the remaining weekdays in the current month.

The expression below calculates all days minus the days into the current month, including weekends.

=DateDiff(DateInterval.Day, Fields!CurrentDate.Value, Fields!LastDay.Value)

Thanks,
Report Builder 3.0

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-06 : 15:14:22
Easier to do in custom code I think. A single expression won't do it. The custom code would loop through the days and add up those that are not Saturday or Sunday.
Go to Top of Page
   

- Advertisement -