Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Rob Scholl Finding the Next Business Day Recursively RE: Finding the Next Business Day Recursively

  • April 26, 2007 at 10:43 am

    #702688

    This did not do it for me:

    select dbo.GetNextBusinessDay(getdate(),1)

    select dbo.GetNextBusinessDay(getdate()+1,1) -- Fri

    select dbo.GetNextBusinessDay(getdate()+2,1) -- Sat

    select dbo.GetNextBusinessDay(getdate()+3,1) -- Sun

                                                         

    ------------------------------------------------------

    2007-04-27 12:41:00

    (1 row(s) affected)

                                                          

    ------------------------------------------------------

    2007-04-30 12:41:00

    (1 row(s) affected)

                                                          

    ------------------------------------------------------

    2007-04-29 12:41:00

    (1 row(s) affected)

                                                          

    ------------------------------------------------------

    2007-04-30 12:41:00

    (1 row(s) affected)