Group Date Range With Specific Range

I know there's lots of grouping in date range. I've looked in the internet. But the one's I saw was hard wired range. Say, CASE WHEN [Date] BETWEEN '2014-1-1' AND '2014-3-30' TH

Solution 1:

Use MONTH()

CASEWHENmonth([Date]) BETWEEN2AND7THEN2ELSE1END

Solution 2:

groupbycasewhenMonth(DateCol) IN (8, 9, 10, 11, 12, 1) then1else2end

Ref: Month()