How ASP queries all records from the previous week in an Access database

Last week (within seven days):
SELECT * from Art where [today] between DATEADD ("WW", -1,now ()) and now ()
Last week (from Monday to Sunday):
SELECT * from Art where [today] between DATEADD ("D",-weekday (Now ()) -5,now ()) and DateAdd ("D",-weekday (now)) +1,now ())
Last month (today to today):
SELECT * from Art where [today] between DateAdd ("M", -1,now ()) and now ()
Last month (1th to the last day):
SELECT * from Art where [now] between dateserial (today), Month (now ()) -1,1) and DateSerial (now), Month (now ()), 1-1



Test:
Select DATEADD ("D",-weekday (Now ()) -5,now ()) Select DATEADD ("D",-weekday (Now ()) +1,now ())
These two are not the dates of the previous Monday and the Sunday, and if so, that is, your table does not have the data that meets the criteria.