Transact SQL Working days

[agibsonsw]

Hello. SQL Server 2005.

I would like to create a user-defined function in Transaction SQL to add, for example, 45 working days to a date.
Does someone have code for this function already? Thanks, Andy.

[Wendell]

Take a look at this question on StackOverflow.com.

[agibsonsw]

Hello. I think that provides the number of days between dates. I want to add a number of working days to a date. Andy.

[HansV]

Try one of these:

SQL Server Forums - Calculate workdays from a date
SQL Server Function to add working days on to a date

[Wendell]

Hello. I think that provides the number of days between dates. I want to add a number of working days to a date. Andy.

Sorry, but I believe you are wrong - the thread is clearly titled "Count work days between two dates in T-SQL" and the code does exactly that with precision varying depending on the post you choose to use. The links Hans provided do the same thing but with different approaches. It's amazing how many different ways you can do things in T-SQL and still have it work (and in many cases only make sense to the original author).

[HansV]

Hi Wendell,

They are not quite the same - the functions in your links calculate the difference between two dates, excluding weekend days. Andy wants to add a number of days to a date, excluding weekend days.

[agibsonsw]

Thank you, that's just what I was looking for. Andy.