Add x number of business days to a date

• TomT

  SSC Eights!

  Points: 887

  More actions

  September 2, 2008 at 3:29 pm

  #192453

  Anyone have or know of a script to get a date based on a number of business days passed in (e.g. to a function).

  E.g., I'd like to calculate the date 10 business days from today.....

  Thanks in advance

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  September 2, 2008 at 4:02 pm

  #866265

  Where are you going to get your list of holidays from?

  If you are not using holidays, then your specific problem is dead easy: 10 business days is always exactly 14 calendar days, so just add 14 days.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]