Help Needed In Writing This Function.

Hi,

   I have Table called performance where i what to get the AsOfDate(char 10)  from that table... and i want to get the most recent based on this function.

 ALTER FUNCTION [dbo].[udf_Quarter] (@Date datetime)
RETURNS char(10)
AS

BEGIN

DECLARE @month int
SET @month = Month(@Date)
RETURN
CASE
WHEN @month BETWEEN 4 AND 6 THEN 5
WHEN @month BETWEEN 7 AND 10 THEN 6
WHEN @month BETWEEN 11 AND 12 THEN 7
WHEN @month BETWEEN 1 AND 3 THEN 8
END
END


 

and i want this to return 3/31/2008 but i want to make it dynamic like if it is   "3/31' and year can be depending on the year it passes

 

Any help will be appreciated.

Thanks

Karen