Why is my pivot table not showing dates correctly?
Just click the down arrow at the top of the column with the date. If you have several row fields, be sure you have a cell selected that shows date data. That will enable the date filters. Unfortunately, this same functionality is not available if you add a date field to the Report Filter area.