2 of 2 people found this helpful
Create a calculated field like this:
[YourDateField] >= DATETRUNC('week',DATEADD('week',-10,TODAY())) AND [YourDateField] < DATETRUNC('week',TODAY())
Drag that field to the filters shelf and set to True.
There are many roads to Rome.....
if DATEDIFF('week',[Date],TODAY())>=1 and DATEDIFF('week',[Date],TODAY())<=10 then [Value] END
Your are welcome.