Fiscal Year Challenge CR XI

[BiJae]

I'm using a parameter field to determine the reporting period. I found the Crystal Reports helpful to get me what I needed thus far. However the formula they provided:

Choose (DatePart ("q", {complaints.DateReceived}), 

           "3rd Fiscal Quarter", "4th Fiscal Quarter", 

           "1st Fiscal Quarter", "2nd Fiscal Quarter")

Works only with federal fiscal year, 07/01/YYYY to 06/30/YYYY. I am looking for a way to tell this formula that I need it to group the months in threes beginning at 3, not 1.

What I'm looking for is

FY07 =

First quarter 09/01/06
Second Quater 12/01/06
Third Quarter 03/01/07
Fourth Quater 06/01/07

Any suggestions will be greatly appreciated.

Thank you,

http://www.bijae.net

"If the only prayer you said in
your whole life was, 'thank you,'
that would suffice."
-- Meister Eckhart

 

[synapsevampire]

Try:

if {month(table.field}) in 9 to 11 then
1
else
if {month(table.field}) in [12,1,2]then
2
else
if {month(table.field}) in 3 to 5 then
3
else
if {month(table.field}) in 6 to 8 then
4

Now you can group on this field.

-k