How to create a Quarter Selection?

[jim_chan]

Hi guys,

Normal standard, when i create a quarter selection it, goes Q1-Q4.

thats what i want. but, due to diff financial year. i need to have a Q1 (Jul-Sep), Q2(Oct-Dec), Q3(Jan-Mar), Q4(Apr-Jun).

How can i do that???

Rite now. without doing anything. i got my quarter arrangement as such Q3,q4,q2,q1

Rgds,

Jim

[Kushal_Chawda]

see this

Fiscal and Standard Calendar generation

In your case SET vFiscalYearStartMonth = 7;

[jim_chan]

i got this.. but is this the only solution?

[Gysbert_Wassenaar]

No, there are hundreds of ways to do this. Here's another: 'Q' & Ceil(Month(MonthStart(MyDate,-6)) /3) as Quarter.

[jim_chan]

thanks Gysbert, i will try it out.

[Kushal_Chawda]

No, there are many ways. see this simple

if(match(month(Date),'Jul','Aug','Sep'),'Q1',

if(match(month(Date),'Oct','Nov','Dec'),'Q2',

if(match(month(Date),'Jan','Feb','Mar'),'Q3',

if(match(month(Date),'Apr','May','Jun'),'Q4'))))  as Quarter,

[Kushal_Chawda · Accepted solution]

try this also

'Q'&Ceil(num(Month(Addmonths(Date,-6)))/3)