Query October 1 previous year to September 30 current year

[turks67 via AccessMonster.com]

How do I query October 1 previous year to September 30 of the current year.

 

[Tom van Stiphout]

On Wed, 12 Aug 2009 14:13:11 GMT, "turks67 via AccessMonster.com"

You could use the DateSerial function e.g.
DateSerial(Year-1, 10,1) is Oct-1 in the previous year.

-Tom.
Microsoft Access MVP

 

[KARL DEWEY]

So on 2 Jan you would only get 3 months of data or do you want the previous FY?

 

[turks67 via AccessMonster.com]

I would like to get the previous FY.

So on 2 Jan you would only get 3 months of data or do you want the previous FY?

 

[KARL DEWEY]

Try this --
Between DateSerial(Year(DateAdd("m",3,Date()))-2, 10,1) AND
DateSerial(Year(DateAdd("m",3,Date()))-1, 9, 30)