SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO CREATE FUNCTION Jaar (@FLTDATE float) RETURNS int AS BEGIN DECLARE @DATE datetime DECLARE @Jaar int SET @DATE = DATEADD(s,@FLTDATE,'1980') SET @Jaar= DATEPART(yyyy,@DATE) RETURN(@Jaar) END GO