SET FirstMonthOfYear=5;

[#1]

I've got SET FirstMonthOfYear=5; in my load editor, but then I use:

QuarterName(PAL_Acceptance_Date) As Accept_QuarterName,

and it still puts Jan-Mar 2020 for a 1/1/2020 date. It is as if it is not seeing the change in the first month. Any ideas?

[#2]

Sorry. I forgot to add.

Dual('Q' & Ceil(Month(PAL_Acceptance_Date)/3), Ceil(Month(PAL_Acceptance_Date)/3)) as Accept_Quarter,

QuarterName(PAL_Acceptance_Date) As Accept_QuarterName,

result is Q1...rather than Q3.

[#3]

I also tried:

'Q' & Ceil(Month(PAL_Acceptance_Date)/3) as Accept_Quarter,

Still getting Q1 for what should be Q3 in our world.

[sunny_talwar]

What if you do this:

'Q' & Ceil(((If(Num(Month(PAL_Acceptance_Date)) < 5, Num(Month(PAL_Acceptance_Date)) + 8, Num(Month(PAL_Acceptance_Date)) - 4)/3) as Accept_Quarter,

[maxgro]

for fiscal quarter calc

Fiscal and Standard Calendar generation

[#6 · Accepted solution]

good idea! I just started a similar vein by adding 4 but hadn't gotten to the point about thiking about 12+4, etc. would not work.

just doctored the parethesis and it worked. thank you!

'Q' & Ceil((If(Num(Month(PAL_Acceptance_Date)) < 5, Num(Month(PAL_Acceptance_Date)) + 8, Num(Month(PAL_Acceptance_Date)) - 4)/3)) as Accept_Quarter,

Still not sure why firstmonthofyear does not seem to work though.

[sunny_talwar]

‌No reward for proposing the idea for using if statement ?

Just kidding. I am glad I wss able to guide you in the right direction.

Best,

Sunny

[#8]

Where's your gofundme? You saved me a good hour or longer.