Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
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.
Hello, I need to get the difference in days between two dates without counting Sundays. Can this be done with DATEDIFF or is there another way to do it?Any help would be greatly appreciated! Thanks!
It should work correctly regardless of your datefirst setting, but check the boundary conditions (when start date or enddate is on a weekend) to see if it is off by 1 and make adjustments as necessary.