
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 04, 2021 09:27 AM
Is there any way to shorten this formula?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 04, 2021 09:39 AM
Couple options:
If your {Month}
field is getting its value from a date field, you could just use DATETIME_FORMAT()
, which has a predefined format for getting the quarter. Do 'Q' & DATETIME_FORMAT({Date field}, 'Q')
.
Or you could stick to using SWITCH()
and just add a little math:
SWITCH(INT(Month / 4), 0, 'Q1', 1, 'Q2', 2, 'Q3', 3, 'Q4')

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 04, 2021 09:59 AM
Awesome Kamille :fire:
INT(Month / 4) is what I was looking for but DATETIME_FORMAT({Date field}, ‘Q’) is even better for me :winking_face:
Thank U👌🏾

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 04, 2021 10:19 AM
There some issues with the INT methods due to “roundness”…
But I found happiness with
CONCATENATE(‘Q’, DATETIME_FORMAT(Date, ‘Q’))
