I have a report with the following columns:

Feb. 2011    Feb. 2010  FY2011   FY2010

The dates are taken from a prompt asking for the Thru date.  All those fields are derived from formulas.  I would like to create a formula that shows all the months for a given fiscal  year.  Plus keep the column for FY2011 and the column showing the previous FY.

I want it to look like this (assuming when I'm prompted, I will be choosing FY 2011 as the current FY):

Jul 2011  August 2011...Jun 2011  FY2011  FY2012

I have the code to create a column based on the current month but how what is the code for previous months?  FY's run 7.1.10 - 6.30.11 (that would be for FY 2011) so I'll also have to take into consideration the years will be changing at some point.

Thanks!  What does the "m" do?  Tell it to look at the month?

In the detail section, I need to keep a total of how many rows are returned that fall within the time period.  So when I run the report, I am prompted for a "Thru" date and I would enter today's date.