fiscal year

[Alex]

I used the following to get the data for the previous
fiscal year (Aug 1 - Jul 31):

Between DateSerial(Year(Date())-2,8,1) And DateSerial(Year
(Date())-1,7,31)

It showed the dates from Aug 1, 2002 to Jul 31, 2003 what
was correct.

Now, it should be Aug 1, 2003 to Jul 31, 2004. But, it
still shows 2002 - 2003.

How could I change it?

Thanks

 

[Gerald Stanley]

Try
Between DateSerial(Year(Date())-1,8,1) And DateSerial(Year
(Date()),7,31)

Hope This Helps
Gerald Stanley MCSD

 

[Alex]

Thanks a lot, Gerald. It's working.
But, in this case I've changed it manually. I can do it
because the new fiscal year is already started.
Is there any way (formula) to get data for the previous
fiscal year avoiding the manual changes with the new
fiscal year starting?

Regards,

Alex

 

[Gerald Stanley]

Try something along the lines of

Between IIf( Month(Date()) < 8 ,
DateSerial(Year(Date())-2,8,1),
DateSerial(Year(Date())-1,8,1)) And IIf( Month(Date()) < 8
, DateSerial(Year(Date())-1,7,31),
DateSerial(Year(Date()),7,31))

Hope This Helps
Gerald Stanley MCSD

 

[Alex]

Thank you very much, Gerald.
It's a very good idea.

Regards,

Alex