fiscal year

  • Thread starter Thread starter Alex
  • Start date Start date
A

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
 
Try
Between DateSerial(Year(Date())-1,8,1) And DateSerial(Year
(Date()),7,31)

Hope This Helps
Gerald Stanley MCSD
 
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
 
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
 
Back
Top