Return only records with a date after the most recent September 1st
Answered my own question, leaving it here for refence for others as I couldn't find the solution anywhere else. By adding 4 months to the date from &quot;dtAssessmentDate&quot; I was able to make the range of values I needed to return as any date from a single year. I extracted the year I am looking for by doing the same 4 month addition to the current date, then using DatePart to exctract the year and only return records who's year matches the extracted year.
Expression in criteria box in access is:
DatePart(&quot;yyyy&quot;,DateAdd(&quot;m&quot;,4,[dtAssessmentDate]))=DatePart(&quot;yyyy&quot;,DateAdd(&quot;m&quot;,4,Date()))