http://sqlblog.com/blogs/louis_davidson/archive/2006/12/09/the-joys-of-a-calendar-table-ytd-month-and-quarter-summations.aspxThere was a question on the forums the other day that asked how to get a total for the current month, the current quarter, and year to date. It is actually a pretty easy task when using a calendar table. I have one you can use here (I fixed an error inenCommunityServer 2.1 SP2 (Build: 61129.1)