Date Parameter Help - prior 13 weeks

[acw1980]

I need to put a date parameter in my query that pulls the last 13 "Full" weeks of data. I get close by using the following:



Between DateAdd("ww",-13,Date()) And Date()


But this actually counts back 13 weeks from current date, which return orders for part of the current week ( week # 46) and orders for part of the first week (week# 33). What I need to achieve is the last 13 full weeks (Sunday - Saturday), so 13 full weeks prior to current week. That make sense? I just can't seem to figure out how to achieve this. I would appreciate any suggestions you might have.

Thanks!

[acw1980]

just for clarification. what I am trying to achieve is the following:


all orders with "delivery date" >= current week number - 14 weeks but not equal to current week number.

Current week number is 46 so desired result would be to get all orders for weeks 32 through 45