The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Kamille_Parks:
SWITCH(INT(Month / 4), 0, ‘Q1’, 1, ‘Q2’, 2, ‘Q3’, 3, ‘Q4’)
There some issues with the INT methods due to “roundness”…
But I found happiness with
CONCATENATE(‘Q’, DATETIME_FORMAT(Date, ‘Q’))