How can I format a quarter year as QQ YYYY e.g. Q3 2024? Custom formats returns the quarter number for each Q in the format box so it looks like 33 2024.
Applying toString to my date variable (so that I can concat a ‘Q’ in from of the 3 2024) returns 2024-07-01 00:00:00.000
month_start is the root date field in my set
quarter prior quarter = addDateTime(-1, ‘Q’, truncDate(‘Q’, {month_start}))
quarter prior year = addDateTime(-1, ‘YYYY’, truncDate(‘Q’, {month_start}))