Set deadlines by adding business days or hours

• John Deupree

  SSCommitted

  Points: 1705

  More actions

  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

• Robin M.

  SSC Rookie

  Points: 36

  More actions

  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!