How do I group date periods by quarter?

[Sales_Manager]

How do I group date periods by quarter?

I used (if-then-else)
month =1,2,3 then Q1
month =4,5,6 then Q2
month =7,8,9 then Q3
month =10,11,12 then Q4

Is there another way?

[Darren_Murphy]

A slightly modified if-then-else column is probably better:

• If Month > 9, then Q4
• If Month > 6, then Q3
• If Month > 3, then Q2
• Else Q1

If there is a possibility of empty date values, then perhaps this:

• If Month > 9, then Q4
• If Month > 6, then Q3
• If Month > 3, then Q2
• If Month > 0, then Q1
• Else N/A

[Sales_Manager]

great, thanks