The function is not recognized when I execute the query.

The only way I have been able the function to work is through statement:

select date from dbo.calcdate('20070227',-4)  But I can use this...

Jeff,

I have the fuction portion written:

create Function dbo.CalcDate

(

@GivenDate    DATETIME,

@NumberOfDays INT

)

Returns table

as

Return  (SELECT dt

   FROM dbo.workcalendar

  WHERE WorkDayCount = (SELECT WorkdayCount FROM dbo.workcalendar WHERE dt=@GivenDate)+@NumberOfDays

    AND IsWorkDay = 1)

My...

Hello Jeff,

Thank you for this, it works great.

I was hoping you could point me in the right direction to using this in my query.  I have a Orders table that contains the date factor and...

I am trying to accomplish something similar to the original post however I would like to use a business day calendar.  I need to take a date like 2/21/2007 and...