Dear Ian
How exactly are you using the FiscalPeriod (date) function?
Does the error only occur when you open the report, or does it actually happen during printing (or preveiwing)? Please tell us what the error is.
If your 'Fiscal Year' does not match the actual Calendar Year, then you may have to create a formula to get the correct fiscal information.
For example, if you want columns on your report for specific fiscal periods, you could custom design some formulas to accomodate this. For example, if your Fiscal Calendar is June 1 through May 31, your formulas would look something like this:
For your fiscal period 12 (May, 2002):
if Month(date) in 5 to 5 and Year(date)= 2002 then amount
You can then format the formula field to 'suppress if 0' to clean up the report.
Alternatively, if you have inserted the 'Fiscal period' field onto your report, the formula for the above FP could be:
if {ALW65 Posted Transactions.Fiscal period} = 12 then {ALW65 Posted Transactions.Home amount}
Hope this helps!