Date criteria one year less than a specific date

[Donna Dible]

I want to find all records greater than 12/31/"last year" for any year. For example, if I wanted 12/31/2010, I could use > #12/31/2011# - 365 to give me 12/31/2010. I cannot figure out how to do it for any given year.

Thanks for your help.

[Rabbit]

Just do greater than or equal to January first of the current year.

>= DateSerial(1, 1, Year(Date())

[NeoPa]

If you specifically want a whole year from any given date then you can use :

([DateField] Between DateAdd("yyyy", -1, {YourDate}) + 1 And {YourDate})

If however, you simply want to match all dates within a particular year then use :

(Year([DateField]) = Year({YourDate}))