Getting Fiscal Year instead of Calendar Year

[Guest]

I have a report that is pulled by a date range (entered in a form), and this
date range is referenced in the report to show the Quarter that is being
pulled. Unfortunately, it is on a calendar year and we are on a fiscal year,
with our fiscal year running from Oct 1 through Sept 30. So currently, if I
want to look at data from Oct 1, 2003 through Dec 31, 2003, my report pulls
the appropriate data but titles the report for Quarter 4, instead of the
correct Fiscal Year Quarter 1. Currently, the formula I use to have it print
the Quarter on the report is this: =Format$([Onset Date],"\Qq yyyy",0,0)

Is there any way for this to be edited or changed so that it will look at
Oct 1 as the first of the year instead of Jan 1? Looking at it as a Fiscal
year instead of a calendar year? Or what would I have to do in order to get
my report to start looking at the dates entered on the form (unbound) and
interpretting them for the right quarter?

Any help would be greatly appreciated on this.

Thanks!

 

[Duane Hookom]

=Format$(DateAdd("q",1,[Onset Date]),"\Qq yyyy",0,0)