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 |
wided
Posting Yak Master
218 Posts |
Posted - 2015-02-13 : 09:44:53
|
I need to calculate the difference in days between dates limits in working days (excluding Sundays)thanks |
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-13 : 11:25:59
|
Use the datediff function. First compute difference in days. subtract difference in weeks (to account for the Sundays). be careful about periods that begin and/or end on a Sunday |
|
|
|
|
|