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.
| 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. |
 |
|
|
|
|
|
Count only Weekdays