possible to use @variable in function?

[cheryl culwell]

when using the following code in my function, I'm getting errors. Is it possible to set a variable and then use it in a function as follows?

if OBJECT_ID ('tvf_Inline_Test') is not null
drop function tvf_Inline_Test
go
create function tvf_Inline_Test(@vstrDate char(15),
@VSTRDTYR char(15),
@mydatevar char(15),
@thismo as char(15))
set @thismo = right ('00' + CAST(DATEPART(Month, getdate()) AS VARCHAR(2)),2)
set @vstrDate = right ('00' + CAST(DATEPART(Month, getdate())-7 AS VARCHAR(2)),2)
--set @VSTRDTYR = CAST(DATEPART(YYYY, GETDATE()) AS VARCHAR(4))
SELECT @VSTRDTYR =
CASE
WHEN @thismo = 12 THEN CAST(DATEPART(YYYY, GETDATE())-1 AS VARCHAR(4))
ELSE CAST(DATEPART(YYYY, GETDATE()) AS VARCHAR(4))
END
set @mydatevar = LTRIM(RTRIM(@VSTRDTYR)) + '/' + LTRIM(RTRIM(@vstrDate))
returns table
as
return select wellID,yearmonth
from well_summary where well_summary.yearmonth = @mydatevar
go

[gpl]

yes you can, but you cannot use getdate() in a function
add another param and pass getdate()in that, then every reference within the function to getdate() should refer to the parameter value