This Week field criteria

[scoughlan]

Apologies for my ignorance in advance! I simply wish to replicate the This Week Date Filter as a date type Field Criteria in a query. Is this possible? The MS Examples of query criteria has this expression: DatePart("ww", [SalesDate]) = DatePart("ww", Date()) and Year( [SalesDate]) = Year(Date()). But, this requests a date input. I simply want it to run with the current date without asking for user input. Thanks for any help you can give me.

[June7]

The Date() function should grab the current date from system, not prompt for input. Is the field SalesDate actual name of field in the query? What is the displayed text of popup prompt?

[scoughlan]

Thanks for helping. Yes, the pop-up prompt is labelled Sales Date. MS describes the criteria such:

Contain dates that fall during the current week. Returns records of transactions that took place during the current week. A week starts on Sunday and ends on Saturday.

[June7]

That means Access is not finding a field by that name and assumes you want user to input a value. The resulting expression is nonsense. What is the name of the field you want to filter on? Use that in place of SalesDate, or is it Sales Date with a space - you show both forms in your posts.

[scoughlan]

Thank you so much. You were quite right: As soon as I changed SalesDate for my own field it worked perfectly. Problem solved!