UDF

[darude]

Hello,
I would need to create a UDF where if I feed it the current year it returns 10/1 of the previous year. Is this possible? Thank you in advance.

 

[RyanEK]

Do you mean 10th of January or 1st of October? In any case, here is one of many ways to do this...

declare @year int
set @year = 2009
select dateadd(yy,-1, convert(datetime,cast(@year as varchar) + '-10-1'))

 

[darude]

Thank you, I'll try it. I meant October 1.