CREATE FUNCTION [dbo].[Date](@Year int, @Month int, @Day int) returns datetime as begin return dateadd(day, @Day-1, dateadd(month, @Month-1, dateadd(year, (@Year-1900),0))) end go