Query to Select This Week

[Mike]

Our business weeks run from Monday to Sunday. Is there any way to create a
query that filters a date field so that it only returns records with a date

= *last* Sunday.

e.g. >=Sunday 31st July 05

and if I run the query next Tuesday it will return records >= Sunday 7th
August 05

Obviously want these queries so that they can be run each week without dates
having to be manually entered or hard coded.

Thanks in advance.

 

[Lori]

Mike~

Try:

=<Now()-7

~Lori

Our business weeks run from Monday to Sunday. Is there any way to create a
query that filters a date field so that it only returns records with a date

e.g. >=Sunday 31st July 05

and if I run the query next Tuesday it will return records >= Sunday 7th
August 05

Obviously want these queries so that they can be run each week without dates
having to be manually entered or hard coded.

Thanks in advance.

 

[Ron Weiner]

Mike

Something like :

= Date()-Weekday(Date(),2)

Ought to work

Ron W
www.WorksRite.com