# Sort by Quarter not available v4.2

**URL:** <https://community.spicecrm.io/t/sort-by-quarter-not-available-v4-2/541>\
**Category:** KReporter\
**Created:** [August 17, 2020, 4:04pm UTC](https://community.spicecrm.io/t/sort-by-quarter-not-available-v4-2/541 "2020-08-17T16:04:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ConstPan](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@ConstPan](https://community.spicecrm.io/u/ConstPan)\
**Post date:** [August 17, 2020, 4:04pm UTC](https://community.spicecrm.io/t/sort-by-quarter-not-available-v4-2/541/1 "2020-08-17T16:04:38Z")

</div>

Hi team, we had a report that included a formula and would split all open opps into quarters. I can’t find the option Quarter in my report, only date. How can I group these by Quarter ? Is it simply adding a formula like they had or creating a new module for Fiscal Period, Quarter, etc. ? The second I would need help with !

Thank you !!

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [September 11, 2020, 6:33pm UTC](https://community.spicecrm.io/t/sort-by-quarter-not-available-v4-2/541/2 "2020-09-11T18:33:31Z")

</div>

apply custom SQL function on date\_closed (or the date field you want to consider)  
CONCAT(YEAR({t}.{f}), ‘-’, QUARTER({t}.{f}))

---

<div class="post-metadata">

**Author:** ![ConstPan](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@ConstPan](https://community.spicecrm.io/u/ConstPan)\
**Post date:** [October 7, 2020, 12:51pm UTC](https://community.spicecrm.io/t/sort-by-quarter-not-available-v4-2/541/3 "2020-10-07T12:51:34Z")

</div>

Thanks for your reply, appreciated. I tried copy/paste but it won’t add it. I took CONCAT off/in took a ( and ) in/off but nothing. Would it be my date format ?

---

<div class="post-metadata">

**Author:** ![ConstPan](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@ConstPan](https://community.spicecrm.io/u/ConstPan)\
**Post date:** [October 7, 2020, 12:56pm UTC](https://community.spicecrm.io/t/sort-by-quarter-not-available-v4-2/541/4 "2020-10-07T12:56:37Z")

</div>

Actually, typed it in instead of copy/paste and it accepted it !