I am trying to structure the query criteria statement to limit query results to only show records where the date values in a date/time field in the query (DateFlagged) are between Date()- 5days a Date()-30 days. I don't want to have to hard-code or prompt for specific dates each time the query is run. Ultimately I will be using this query to generate a report.
I have tried several strings to get this to work - Here's what I have tried so far:
Between Date()-5 And Date()-30
Between DateAdd("d",-5,Date()) and DateAdd("d",-30,Date())
>Date()-5 and <= Date()-30
None of them return the results I expect. I am sure it is something very simple and I am just overthinking this....
Any help would be appreciated!