Run a query based on a start date and end date. The date are the .

[santana]

In access 2000, I trying to run a query based on a start date and an end
date. The start date is Monday from previous week and the end date is Monday
from current week. Is there a way to automate the query?

 

[Rick Brandt]

In access 2000, I trying to run a query based on a start date and an end
date. The start date is Monday from previous week and the end date is
Monday from current week. Is there a way to automate the query?

Monday of "this week"...
DateAdd("d", -((WeekDay(Date(), vbSunday)-2)), Date())


Monday of "last week"...
DateAdd("d", -((WeekDay(Date(), vbSunday)))-5, Date())

(both assume the week starts on Sunday)

 

[santana]

Rick, I used your suggestion and i get the following error message: "The
expression you entered has a function containing the wrong number of
arguments. I used the dateadd function in the criteria of the query in the
"package approved date field" with the "Between" function.

 

[Rick Brandt]

DateAdd("d", -((WeekDay(Date(), vbSunday)-2)), Date())

In a query you can't use the constant vbSunday. Replace that with the
number 1.

 

[santana]

I tried and it worked. Thank you very much

In a query you can't use the constant vbSunday. Replace that with the
number 1.