kbay808
asked on
How to set the date filter in an excel pivot table to “Before =TODAY()”
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?
ASKER
I could not get it to work. I attached the workbook so you can see what I’m working with along with the key data for the macro.
Open-Tickets-Report-v2.2.xlsx
Table-and-field-names.txt
Open-Tickets-Report-v2.2.xlsx
Table-and-field-names.txt
Add a column to the source data with the following formula, assuming date is in column A:
=A1<TODAY()
This will return TRUE or FALSE.
If you then add the column into the Pivot Table you can filter on TRUE.
Thanks
Rob H
=A1<TODAY()
This will return TRUE or FALSE.
If you then add the column into the Pivot Table you can filter on TRUE.
Thanks
Rob H
ASKER
Using "=A1<TODAY()" won't work, because the field also contain blanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked perfectly. Thanks
http://c3412576.r76.cf0.rackcdn.com/03_02_12.xlsm
http://c3412576.r76.cf0.rackcdn.com/03_02_12.pdf