Report with current fiscal year in header

  • Thread starter Thread starter pcbins
  • Start date Start date
P

pcbins

I wanted a report to automatically insert the current fiscal year in the
header (like "2008-2009").

So I inserted a text box and put in this:

=IIf(Month()<7,Year()-1&"-"&Year(),Year()&"-"&Year()+1)

But I keep getting an error message saying I have too many parameters.

Help please?
 
Nevermind, I didnt insert "Now()":

=IIf(Month(Now())<7,Year(Now())-1 & "-" & Year(Now()),Year(Now()) & "-" &
Year(Now())+1)

Sorry.
 
Back
Top