I have a pivot table that needs to be filtered to show all the records before the current date. Here is the way that I do it right now. Date Filters>Before> (Today’s date). It will not accept “=TODAY()” as the value, so I have to manually set this every day. Is there another way to accomplish this?