# How do I group date periods by quarter?

**URL:** <https://community.glideapps.com/t/how-do-i-group-date-periods-by-quarter/45413>\
**Category:** Ask for Help\
**Created:** [July 28, 2022, 10:10am UTC](https://community.glideapps.com/t/how-do-i-group-date-periods-by-quarter/45413 "2022-07-28T10:10:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\
**Post date:** [July 28, 2022, 10:10am UTC](https://community.glideapps.com/t/how-do-i-group-date-periods-by-quarter/45413/1 "2022-07-28T10:10:33Z")

</div>

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?

 ![tt](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/32ec79f7d6fdd39468f6c3582e40ccc0765cc1a5.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 28, 2022, 10:22am UTC](https://community.glideapps.com/t/how-do-i-group-date-periods-by-quarter/45413/2 "2022-07-28T10:22:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\
**Post date:** [July 28, 2022, 10:26am UTC](https://community.glideapps.com/t/how-do-i-group-date-periods-by-quarter/45413/3 "2022-07-28T10:26:10Z")

</div>

great, thanks

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 29, 2022, 10:26am UTC](https://community.glideapps.com/t/how-do-i-group-date-periods-by-quarter/45413/4 "2022-07-29T10:26:32Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.