Home Forums Article Discussions Article Discussions by Author Discuss content posted by J Gravelle SQL Function : Find ‘X’ Business Days in the Future RE: SQL Function : Find ‘X’ Business Days in the Future

  • February 4, 2009 at 4:49 am

    #937825

    Nigel Rutter (2/4/2009)

    Amit Lohia (2/4/2009)

    This can be done without a loop.

    Any possibility you could expand on this?

    Here is the logic but if you want me to write the script let me know.

    Calculate dtEndDate by Simply adding dtBeginDate + iBizDays.

    Find number of records between dtBeginDate and dtEndDate from your holiday table (inclusive of both dtBeginDate and dtEndDate).

    Add that number to your dtEndDate.

    Note: There is a flaw with this approach but I think we also be handled by modifying the table.

    For example, if there is a holiday between the dtEndDate from step 2 and dtEndDate from step 3.

    Also, You can always add weekends as part of your table.

    Kindest Regards,

    Amit Lohia