Hello all,
I'm trying to create a query that will give me all of the records for the last 12 months, but I want to exclude the current month from the results. I'm currently using the DateSerial Fx in the criteria. It's currently November 2023.
When I use
>=DateSerial(Year(Date())-1,Month(Date()),1)
I get the records from November 2022 - November 2023
When I use
>=DateSerial(Year(Date())-1,Month(Date())-1,1) (red to indicate the only difference btwn the two functions)
I get the records from October 2022 - November 2023
How can I exclude November 2023 (the current month) from the results?
Thanks in advance!