Quater creation (adding the required months to the Q1,Q2,Q3,Q4).

[#1]

Hi Floks,

When we create the calender , (Jan,Feb,Mar will fall under Q1, Apr,May,June will fall under Q2, July,Aug,Sep will fall under Q3, Oct,Nov,Dec will fall under Q4).

But i would like to display the (Nov,Dec,Jan into the Q1, Feb,Mar,Apr into Q2.... respectively )

Can Some one Help on this.

Regards,

Rajesh.

[MK_QSL]

Create an Inline Table as below..

Load * Inline

[

     Month, Quarter

     Nov, Q1

     Dec, Q1

     Jan, Q1

     Feb, Q2

     Mar, Q2

     Apr, Q2

     May, Q3

     Jun Q3

     Jul, Q3

     Aug, Q4

     Sep, Q4

     Oct, Q4   

];

[maxgro]

check this if you want to shift quarter

Issue with Quarter!

[aveeeeeee7en · Accepted solution]

Hi Rajesh

See the Attached.

Its Simple and easy.

Use this Code in your script and do replace the Date with your Date:

'Q'&Ceil(Num(Month(AddMonths(Date,-10)))/3)

as [Fiscal Quarter]

Regards

Aviral Nag

[#5]

Hi Nag Tanks a lot