Criteria for "General Date"

[CRISTOS]

Hello,
In Access, how could I get the:
1. Last week Dates
2. Dates between Last week and start of previous month
The field name is "Delivery_Date"
The data format is "General Date" : 7/15/2022 1:39:11 PM
Thank you!

[HansV]

In a query based on the table, add the Delivery_Date field to the query grid.
For dates in the last week, enter the following in the Criteria row of this column:

Between Now()-7 And Now()

For dates between the start of the previous month and last week, enter the following in the Criteria row of this column:

Between DateSerial(Year(Date()),Month(Date())-1,1) And Now()-7

[CRISTOS]

Much appreciated!!