How to create Quarters starting from April to March in the script?

[jblomqvist]

Hi all,

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.

[sunny_talwar · Accepted solution]

May be create a fiscal year calendar?

Fiscal and Standard Calendar generation

[aarkay29]

you can use this

'Q' & ceil(if(num(Month(TempDate))<= 3, Month(TempDate)+(12 - 3), Month(TempDate) - 3)/ 3) AS FiscalQuarter,