2 of 2 people found this helpful
Try creating a calculated field with codes like this:
DATEDIFF('day', Today(), [Date]) < 0 //Yesterday AND DATEDIFF('day', Today(), [Date]) >= -X //X Days Ago
Replace the X with an integer value (hard-coded or a parameter) to give X days ago, but not including today.
Replace 'day' with 'week' or 'year' on the third line as desired.
Then place that new calculated field on the Filters shelf and keep only TRUE values.
Hope that helps! Please let me know if you have any questions.
Matthew: Please mark this question as "answered" if Joshua's solution works for you--thanks for helping us keep the forums "clean"!