Query dates for current week and prior

[farmerde]

Hello All,

I am trying to filter the dates in a Query so that only dates for the current week and dates that are older than the current week are returned. I haven't had much luck and I would appreciate your suggestions.

[JoeM]

Try this criteria:

<=Date()+7-Weekday(Date())

[farmerde]

Perfect, thanks JoeM. I was trying all of these elaborate combinations using DatePart function but this is exactly what I needed.

David

[JoeM]

You are welcome. Note. If you dates have a time component to them that is not zero, you will need to alter it a bit to:

<Date()+8-Weekday(Date())