Could someone please show me how to create Quarters where they start from April and end in March? In something like a Master Calender script would be great.
May be create a fiscal year calendar?
Fiscal and Standard Calendar generation
you can use this
'Q' & ceil(if(num(Month(TempDate))<= 3, Month(TempDate)+(12 - 3), Month(TempDate) - 3)/ 3) AS FiscalQuarter,
Retrieving data ...