InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 01:14:18 GMT20http://www.sqlservercentral.com/Forums/Topic993277-2793-1.aspxAs far as I know the quarter function went away a long time ago. Anyway, one thing to note is that this should be a single function (even though I don't like functions at all) with a @mode parameter. Say 0 for start and 1 for end.Mon, 27 Sep 2010 07:22:48 GMTjfogel-1131029http://www.sqlservercentral.com/Forums/Topic993277-2793-1.aspxAfter correcting the errors I was able to run this query. Is it just me or shouldn't the first quarter of 2010 be 01-01-2010 to 3-31-2010, not 10-01-2009 to 12-31-2010. Why does this return the last quarter of 2009 dates?? I know some shops, like mine, have June as the beginning of the Fiscal year, so maybe his shop has October. Since there were no notes as to this, it's hard to tell. The solution is interesting, but the date functions cover quarters already, or SQL use to cover this.-Callie97Mon, 27 Sep 2010 06:01:38 GMTcallie97http://www.sqlservercentral.com/Forums/Topic993277-2793-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/71242/">Pass in Year and Quarter and get the fiscal start and end dates</A>[/B]Sat, 25 Sep 2010 11:28:11 GMTsriman.bapatla