After 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.

-Callie97