Within my solution I also have a month and year field, say January and 2011.
If I wanted another calc field to say if the month falls in a specific quarter say "Quarter 1" what would the case function be?
Case (Field = "January" ; Field::Quarter 1 )
But the next 11 months? and also it does not work as I am writing it.