Previous Year and Specified Month in Select statement VBA

[BLFOSTER]

I am trying to pull dates via select statement in VBA for the previous year(2013) and month of September. This definitely does not work. Please tell me how to write this if you can!

"SELECT * FROM MyQuery " _


& "WHERE [MyDate] Between DateSerial(Year(Date()-1),Month(9),1) And DateSerial(Year(Date()-1),Month((9)),0)"

[June7]

The -1 is misplaced.

"SELECT * FROM MyQuery WHERE [MyDate] Between DateSerial(Year(Date())-1,9,1) And DateSerial(Year(Date())-1,9,0);"

If you want only the month of September, consider:

"SELECT * FROM MyQuery WHERE Year([MyDate])=Year(Date())-1 AND Month([MyDate])=9;"

[BLFOSTER]

Thanks! Works beautifully!