Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need a function to Calculate Next Business Days Expand / Collapse
Author
Message
Posted Monday, November 26, 2007 6:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, November 29, 2007 6:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 11:08 AM
Points: 102, Visits: 37
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 »

Add to briefcase

Permissions Expand / Collapse