T
turks67 via AccessMonster.com
How do I query October 1 previous year to September 30 of the current year.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Query October 1 previous year to September 30 current year
T
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
You could use the DateSerial function e.g.
DateSerial(Year-1, 10,1) is Oct-1 in the previous year.
-Tom.
Microsoft Access MVP
K
KARL DEWEY
So on 2 Jan you would only get 3 months of data or do you want the previous FY?
T
turks67 via AccessMonster.com
I would like to get the previous FY.
KARL said:So on 2 Jan you would only get 3 months of data or do you want the previous FY?
K
KARL DEWEY
Try this --
Between DateSerial(Year(DateAdd("m",3,Date()))-2, 10,1) AND
DateSerial(Year(DateAdd("m",3,Date()))-1, 9, 30)
Between DateSerial(Year(DateAdd("m",3,Date()))-2, 10,1) AND
DateSerial(Year(DateAdd("m",3,Date()))-1, 9, 30)