Hello

I was wondering if anyone can offer me any advise on the following problem I have.

I have created a cashflow report, my problem is the year is not being taken into consideration.  So on my report the values are appearing in the wrong year column.

Eg. 

My report runs Oct 2011 - Sept 2012
If I add 3 months to Aug 2012 the value appears in Nov 2011 field.

I have include a section of my code and I know its because I haven't included the year, but I'm not sure how I go about doing this.


.....
.....
Case "One Off":
If (Month ({Sheet1_.Monthstart})=Month (DateAdd("m",3,{OPPORTUNITY.ESTIMATEDCLOSE}))) Then {@First_Year_Fees}

Thank you

Sarah 

Thank you for your response. 

I neglected to say also that I'm using a crosstab!

So there is no group on date.  The dates are display across the top of the crosstab.

Please let me know if you require any other information.

Sarah