Need a function to Calculate Next Business Days

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Need a function to Calculate Next Business...

Need a function to Calculate Next Business Days

Rate Topic

Display Mode

Topic Options

Author

Message

Niranjan C

Posted Monday, November 26, 2007 6:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 22, 2009 5:04 AM
Points: 1, Visits: 22

Dear All,

I need a function to do the following steps

1. Function to add number of days given by user.
2. While adding it should nt consider Sunday,Saturday and Monday.
3. obtained date should fall under thursday or friday and also third week of that month.
4. If not next possible third week thurday/ firday has to be obtained and again that should go thru the following things.
Please help

Post #425736

Camilo Torres

Posted Thursday, November 29, 2007 6:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 18, 2012 1:30 PM
Points: 102, Visits: 34

Check this out

http://www.sqlservercentral.com/articles/Advanced+Querying/findingthenextbusinessdayrecursively/2125/

Google this: sql to calculate next business day...you may find other approach.

Post #427391

« Prev Topic | Next Topic »

Permissions