InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:30:47 GMT20http://www.sqlservercentral.com/Forums/Topic740730-253-1.aspxdeclare @date datetimedeclare @days intdeclare @weeks intselect @date = '2009-06-21'select @days = 1if (@days < 0)begin if datepart (dw, @date) = 1 select @date = dateadd (d, -1, @date) select @weeks = (datepart (dw, @date) + @days - 6)/5endelsebegin if datepart (dw, @date) = 7 select @date = dateadd (d, 1, @date) select @weeks = (datepart (dw, @date) + @days - 2)/5endselect dateadd (d, @days + (@weeks*2), @date)Tue, 23 Jun 2009 21:56:53 GMTmaluthwattahttp://www.sqlservercentral.com/Forums/Topic228794-253-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/rScholl/findingthenextbusinessdayrecursively.asp">http://www.sqlservercentral.com/columnists/rScholl/findingthenextbusinessdayrecursively.asp</A>Thu, 13 Oct 2005 13:03:00 GMTRob Scholl