Alter Function GetCalanderDaysFromBusinessDays (@BusinessDay int)

Returns Date

as

Begin

Declare @CalanderDays int

Declare @FinalDate Date

Set @CalanderDays = ((@BusinessDay/5)*7) + (@BusinessDay % 5)

Set @FinalDate = DateAdd(Day, @CalanderDays, GetDate())

Return @FinalDate

End

An Excellent article Andy. I am a beginner of SSIS and this article makes me everything so clear and easy. I am really waiting forward for next articles.