How do I Use Relative Dates as Query Criteria

[riverist]

It seems (and probably is) simple, but I can't find a statement that works.

I want to find all records where the field IssueDate is after June of the current year and before July of the next year.

I can hard code it for 2016 by putting >#6/30/2016# And <#7/1/2017# in the criteria, but I'd like to do it so it works any current year.

Everything I try produces an error.



Thanks!

[pbaldy]

See if this gives you some ideas:

?DateSerial(IIf(Month(Date()) < 7, Year(Date()) - 1, Year(Date())), 7, 1)
7/1/2015