Report with current fiscal year in header

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?
 
P

pcbins

Nevermind, I didnt insert "Now()":

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

Sorry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top