SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION dbo.fn_Week_naar_Datum( @Mydate datetime)
		--@Tabel  as VARCHAR(30)
	

RETURNS  varchar(20)	

AS  
BEGIN 
Declare @x as varchar(20)
Declare @day as varchar(20)
Declare @Maand as varchar(20)
Declare @Jaar as varchar(20)
Declare @y as Datetime

DECLARE @Year int, @Week int;
--SELECT  @Year = 2007;
SELECT  @Year =   datepart(year,@MyDate)
SELECT @Week =   datepart(week, @MyDate)

SELECT @y = DATEADD(wk, (@Week ),  DATEADD(dd, 0, DATEADD(wk, DATEDIFF(wk,7,Convert(varchar(4),  @Year) + '-01-01'), 0)))
 
Set @day = datepart(day,@y)
Set @maand = datepart(month,@y)
Set @jaar = datepart(Year,@y)
SELECT @x = @day + '-' + @maand + '-' + @jaar

RETURN(@x)
END



GO