I need to run a query that updates every year for my report, to find a set of records from 01/09 of the year up to 01/11. I want to base my query on the system date so that if the 'year' is the same as the system date then I get the current years records, but if the year has rolled over( and not reached the Sept month yet) then I will get last years 'Sept date', without having to input or use a paremeter query to ask which year. JonK has already supplied me with this piece of code which works great- 'Between IIf(Format(Date(),"mmdd")>"0831",DateSerial(Year(Date()),9,1),DateSerial(Year(Date())-1,9,1)) And Date()' but I cant seem to get it to work right to limit the date range.
Last edited:
