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


Group: General Forum Members
Last Login: Friday, August 21, 2015 1:05 PM
Points: 102, Visits: 45
Check this out

Google this: sql to calculate next business may find other approach.
Post #427391
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse