Find date of the beginning and of LAST week

[krets]

Is there a way to find the beginning and end of last week (week starts on Monday and ends on Friday) in a query?

 

[krets]

Damn fat fingers.

What I would like to do is set the first and last day of the previous week for the WHERE clause of my query. So the query will return only those records with a date of last week.

 

[VRoscioli]

Last Friday is Int(Now()-Weekday(Now(),vbSaturday))
Last Monday is Int(Now()-Weekday(Now(),vbSaturday)-4)

You might need to check the syntax on that, though.

-V

 

[krets]

When I tried that method I would get a "vbSaturday" text box.

Here's what I ended up doing:

WHERE tblAITInfo.AITDate >= (Date() - WeekDay(Date()) - 6) AND tblAITInfo.AITDate <= (Date() - WeekDay(Date()));