SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION dbo.fn_JaarBegin ( @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


Set @Y = DATEADD(Year,-1,@MyDate)


DECLARE @Year int, @Week int;
--SELECT  @Year = 2007;


 
Set @day = datepart(day,@y)
Set @maand = datepart(month,@y)
Set @jaar = datepart(Year,@y)
SELECT @x = @jaar




RETURN(@x)
END
GO