How can I set a weekly Date Criteria

othmanyg

Registered User.
Local time
Today, 19:48
Joined
Feb 1, 2000
Messages
43
Greetings to all,

I need help in a date criteria in a query, What's the criteria if i want to pull a weekly report based on date field. let's say i want the report to view the items from Monday to Sunday.

Your quick help is much appreciated.
Good day,
 
Have a look at the DateAdd() function as it can make queries very flexible for date reporting.

Here's a criteria that will return all records where the date field in question includes a date within the last seven days.

Between DateAdd("d", -7, Date()) And Date()
 
Great, many thanks

Thanks very much Mile-O-Phile, it worked, that's exactly what i need.
 

Users who are viewing this thread

Back
Top Bottom