calculate business days - SQL Server Forums

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 2000 Forums

SQL Server Development (2000)

calculate business days

Author

Topic

webguru22
Starting Member

11 Posts

Posted - 2001-09-04 : 18:21:18

Hi, anyone got a good snippet to calculate dates using only business days (M-F) omitting weekends?

Specifically Id like to add 3 business days to a given date. So if today is Thursday, the result would be next tuesday's date.

thanks for any advice.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources