Filter Dates in current week

[gloudo]

Hi there,

I like to filter all the records in a query of wich the date is in the current week. And when the week changes the dates of that week must be filtered, and so on.

Can anybody tell me the expression for this query?

thanks

 

[PaulBricker]

Use the DatePart Function. In a new column in your query put
MyWeekatePart("ww",[DateFieldName])

Then on the criteria line for this column put
=DatePart("ww",Date())

That will return the records for the current week.

Paul

 

[mp9]

Assuming you're taking Sunday as the first day of the week, then you need a WHERE clause something like this in your query:

WHERE [NameOfYourDateFieldHere] BETWEEN (Date()-Weekday(Date(),1)) And (Date()+(7-Weekday(Date(),1))

Hope this helps.

http://www22.brinkster.com/accessory/