3 Replies Latest reply on Jan 28, 2010 1:06 PM by penhaifai

# Identifying two periods of fyscal year!!

### Title

Identifying two periods of fyscal year!!

### Post

How can i put two parts of fyscal year in a way that i can assign a letter to each of these periods. i.e.;

A                                                       B

---                                                     ---

Oct,1st-Mar,30th                                Apr,1st-Sep,30th

As you can see, the equation should b a general one so it would fit any year and since the "A" period; Info_ReportingPeriod;  has two different years; the current one and the one after, unlikethe second period "B"; Info_ReportingPeriod; that doesnt have that issue

A= 11/1/2009-3/30/2010                               B=4/1/2010-9/30/2010

Remember that it should be a general equation since it would work with any fyscal year.

The way that it works with is when you put the record date; Info_IntakeDate; it will calculate if that record is in "A" or "B" period of fyscal year; Info_ReportingPeriod.

Thank you

• ###### 1. Re: Identifying two periods of fyscal year!!

penhaifai wrote:

A= 11/1/2009-3/30/2010                               B=4/1/2010-9/30/2010

What happened to October?

• ###### 2. Re: Identifying two periods of fyscal year!!

Ah, I see you have it under A here:

penhaifai wrote:

A                                                       B

---                                                     ---

Oct,1st-Mar,30th                                Apr,1st-Sep,30th

So try =

Case ( Mod ( Month ( Info_ReportingPeriod ) - 4 ; 12 ) > 5 ; "A" ; "B" )

• ###### 3. Re: Identifying two periods of fyscal year!!

Thank u very much Comment and yes I missed a one whole month here lol =) sorry 4that =)

and thank you for you great help!!