Here is a sample report that converts a date field to quarter and fiscal year values
START WITH DocumentSELECTId,CASECAST (DateEffective AS STRING, 'MM') WHEN '10' THEN 'Q1' WHEN '11' THEN 'Q1' WHEN '12' THEN 'Q1'…