I am very new to pivot tables but some searching through forums still didn't give me any answers.

Capture.JPG

My spreadsheet has pivot tables that sort through a data dump from our asset management software that tracks reported defects. My goal is to have this pivot table only display rows with a date first reported that is two months or older. However using the predefined Date Filters I can only show values from last month, which does not show anything earlier or I can select Before... which only works with specified dates and returns a "This isn't a valid date" error if I try and use standard Excel logic like =EDATE(TODAY(), -2)

Capture.JPG

Hopefully I am just missing something simple but any help would be great