This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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’))