eric.rajala

Here is a sample report that converts a date field to quarter and fiscal year values

START WITH Document
SELECT
Id,
CASE
CAST (DateEffective AS STRING, 'MM') 
WHEN '10' THEN 'Q1' 
WHEN '11' THEN 'Q1' 
WHEN '12' THEN 'Q1'…