Hey there,

The problem I have is that the Report Filter function doesn't seem to allow using 'Greater than' or 'Less than' filter functions.

I have a few pivot tables that include two date fields "Date From" and "Date To" (format: dd/mm/yyyy). The dates are weeks (ei. 29/09/2014, 06/10/2014, 13/10/2014… etc.). I have set them up in such a way that the "Date From" and "Date To" fields are set as
"Report Filters" in the pivot table.

An example of this would be if IU I or users would like to see the data for the last 2 weeks instead of all 26 weeks that are currently available (or 3 weeks, 5 weeks, 15 weeks.., as we select in the filter)
How can I set up the Report filters to do the two following weeks for example:
- "Date From" filter: >= 29/09/2014 (in words: greater than or equal to this date)
- "Date To" filter: <= 13/10/2014 (in words: smaller or equal to this date).

It seems like it's something that many people would also want to do but I can barely find anything on this online. Do you have any idea how to do this?

Thanks!

Geoff