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
 Transact-SQL (2012)
 date fonction

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
Go to Top of Page
   

- Advertisement -