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

  • November 9, 2006 at 5:57 pm

    #670964

    I don't understand the @numDays input parameter!

    For example if do this,

    DECLARE

    @Date SMALLDATETIME

    SET

    @Date = dbo.fnGetNextBusinessDay ('2006-12-24', 10)

    SELECT

    @Date

    It's suppsoe to return the date 2006-12-27 as that is the next business day.

    Can someone explain please?

    Kindest Regards,