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!
Criteria for "General Date"
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Criteria for "General Date"
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
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
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 24
- Joined: 23 Nov 2018, 20:24
Re: Criteria for "General Date"
Much appreciated!!