You're correct. Unfortunately the date filter isn't available in the
Report Filters. You can manually uncheck the dates in the Report Filter
dropdown list.
Or, add a column to the source data, to compare the record's date with
the target date. For example: =A2<Report!B5
Add that field to the Report Filters, and filter for TRUE
Hutch wrote:
I am putting together a pivottable and would like to be able to filture the
report for all records that are less than a certain date. However, it does
not appear that the "Date Filter" option is available for fields you put in
the Report Filter section. Am I missing something?
I know I could move the date field in question down to the Row Labels
section to use the Date Filter, but my problem is that I do not want to it
group on that field since almost each record has a different date.
Thanks, for any help that you can give.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html