How can I set a weekly Date Criteria

[othmanyg]

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,

 

[Mile-O]

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()

 

[othmanyg]

Great, many thanks

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