I have this code that calculates the date in quarters. My financial year is july to Dec. It works fine except that it sees june 2012 in the fouth quarter.
How do I modify this?
You posted a lot of confusing information. July to Dec is 6 months, not a year. So does that mean your quarters are 1.5 months? If not, then it sounds like June should be Q4. If so, then June shouldn't be in your data at all.
sorry meant july to june. I agree June should be in the 4th quater but not in the current financial period. the financial period is july 2012 to june 2013. but june 2012 is in the 4th quarter of the 2012-2013 year
hope this is clearer
thanks