Crystal 11 Quarter to Date but non-standard Quarters

[Jkensy]

Hi all - I want to total a number based on what quarter it was booked. The problem is, my company uses the following for fiscal quarters:

4Q13 – 12/31/13
1Q14 – 3/28/14
2Q14 – 6/27/14
3Q14 – 9/26/14
4Q14 – 12/31/14

How can I split the quarter such that 9/27 is 3Q 2013 but 9/28 is 4Q 2013.

Thanks all

 

[briangriffin]

As usual I'd suggest a custom date table - that would make this simple for this report and all future date-based reporting. For your oddly defined quarters you'd pretty much have to store the dates somewhere anyway.

 

[SkipVought]

I'd endorse briangriffin's suggestion for sure!

Your days per quarter: 87, 91, 91, 96
Your weeks per quarter: 12, 13, 13, 14



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[pomster]

I used this sometime ago, might be able to adapt..

Function (DateVar v1)


//Q1 = Mar Apr May
If Month(Today) >=3 and Month(Today)<=5 then
    (Year(v1) = Year(Today) AND Month(v1) in [3,4,5])
Else

//Q2 Jun Jul Aug
    If Month(Today) >=6 and Month(Today)<=8 then
        (Year(v1) = Year(Today) AND Month(v1) in [6,7,8])
    Else

//Q3 Sep Oct Nov
        If Month(Today) >=9 and Month(Today)<=11 then
            (Year(v1) = Year(Today) AND Month(v1) in  [9,10,11])
        Else

//Q4 Dec Jan Feb
            If Month(Today) = 12  then
                (Year(v1) = Year(Today) AND Month(v1) = 12) 
Else

        If Month(Today) in [1,2]  then
            (Year(v1) = Year(Today) AND Month(v1) in  [1,2]

                and      Year(v1) = Year(Today)-1 AND Month(v1)= 12 )

regards,


David

CRXIR2 with CRXIR2 server and SQL 2005
CR2008 with CR2008V1 Server and SQL 2005