Find all records within current week? 3

[jazminecat]

Hi all -

I have a table with dates in mm/dd/yy format. I need to write a query to find all records with a date during the current week. I can find all records for today using
Date() or Now()
but can't find a similar function to find all records for the current week. I need to be able to run this on any day of the week.

thanks!

 

[GoDawgs]

Assuming a Sunday-Saturday week put this in the criteria of the date field:

>=Date()-Weekday(Date())+1 And <=Date()+(7-Weekday(Date()))

That should do it. Hope that helps.

Kevin

 

[jazminecat]

works like a charm! thanks again godawgs. star for you!

 

[johnaregan]

saved me some work and thinking, have another star