SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Adeoye Omoboya / T-SQL Function to Determine Holidays in SQL Server / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 22:27:27 GMT20RE: T-SQL Function to Determine Holidays in SQL Serverhttp://www.sqlservercentral.com/Forums/Topic586720-1346-1.aspxhi thanks for coll function but when i tried to execute it i got an error would you help me to solve this problem ?the error is "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."thanks MiMThu, 27 Nov 2008 06:57:05 GMTMiM-602164RE: T-SQL Function to Determine Holidays in SQL Serverhttp://www.sqlservercentral.com/Forums/Topic586720-1346-1.aspxSome meaningful variable names would go a long way toward making this readable.Tue, 25 Nov 2008 10:37:22 GMTstephen.hendricksRE: T-SQL Function to Determine Holidays in SQL Serverhttp://www.sqlservercentral.com/Forums/Topic586720-1346-1.aspxThe Title is completely misleading. "Date of Easter" formulas have been around for decades. It was one of my early computer science homework assignments.Mon, 24 Nov 2008 10:16:44 GMTMauveRE: T-SQL Function to Determine Holidays in SQL Serverhttp://www.sqlservercentral.com/Forums/Topic586720-1346-1.aspxThis is cool and all, but how often does Easter make that big of a difference to a business? How about a function for the holidays that most people actually get a day off for.Mon, 24 Nov 2008 08:45:24 GMTBrett PhippsT-SQL Function to Determine Holidays in SQL Serverhttp://www.sqlservercentral.com/Forums/Topic586720-1346-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/64641/">T-SQL Function to Determine Holidays in SQL Server</A>[/B]Wed, 15 Oct 2008 23:17:45 GMTadeomoboya