Post reply

Set deadlines by adding business days or hours

  • November 13, 2007 at 5:54 am

    #183786

    Comments posted to this topic are about the item Set deadlines by adding business days or hours

    John Deupree

  • July 2, 2013 at 3:00 am

    #1628950

    When I use minutes and seconds in the start date, it does not add the minutes.

    DECLARE@return_value int,

    @dEndDate datetime

    SELECT@dEndDate = N'2013-06-29 21:39:07'

    EXEC@return_value = [dbo].[bcssp_AddBusinessHours]

    @dBegDate = N'2013-06-29 21:39:07',

    @iHours = 10,

    @cBusBeg = N'08:00:00',

    @cBusEnd = N'18:00:00',

    @dEndDate = @dEndDate OUTPUT

    SELECT@dEndDate as N'@dEndDate'

    SELECT'Return Value' = @return_value

    Gives me "2013-07-02 08:00:00.000" as the result...

    Sorry, did not see that my startdate was at saturday, calculation is correct!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply