Less than current month last year

[paulinec]

I am trying to filter data that is dated less than the current month last year.
Would appreciate any help with this.
Thank you

 

[Ken Snell [MVP]]

WHERE DateFieldName < DateSerial(Year(Date())-1, Month(Date()),1)