I am trying to specify in a query that I want it to only show data that meet a specific criteria. Only records with a lost date from two months ago. So for example, this being June, it should only show records from April 2018. July would show May and so on.
I have put the following condition (which I know is not the correct one for my particular question, but I was hoping I would be able to work on it to suit my requirements):
[MaxOfLostDate]>=DateSerial(Year(Now())-1,1,1) And [MaxOfLostDate]<=DateSerial(Year(Now())-1,Month(Now()),Day(Now()))
This kind of works but it should show records from last year to present date, but it only shows last years data.
Does anyone know what I can do to fix this to meet my requirements or have another criteria I could use?
thanks
Alistair