VBA code to filter pivot table by rows containing dates for dates < 60 months old

**BrokenDome** · 06-19-2019, 12:30 PM

Hello again!!

Just wondering if someone could help me out. I have a pivot table containing a large amount of data. My date field is inside the row area. I would like to filter the dates to contain only those dates to include only the information for the past 60 months. Currently I am working on a code like this:

Please Login or Register  to view this content.

wholeEndDate is a string made from user input to create today's date. The value looks like this: "05/31/2019".

Unfortunately this is not working. Any help is much appreciated!!

Dome

**AlphaFrog** · 06-19-2019, 01:28 PM

This is a guess, but give it a try

Please Login or Register  to view this content.

It converts the date string to a date value, subtracts 60, and converts the new date value back to a date string.

VBA code to filter pivot table by rows containing dates for dates < 60 months old

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to filter pivot table by rows containing dates for dates < 60 months old

Re: VBA code to filter pivot table by rows containing dates for dates < 60 months old

Thread Information

Users Browsing this Thread

Similar Threads

Will pivot table update with new dates without needing to select the dates in the filter?

Pivot table - Filter by dates

Filter recognizes dates, but Pivot Table filter does not

VBA Code to filter rolling dates from a pivot table

[SOLVED] VBA code to filter on Specific two dates ( pivot table)

Select Multiple Dates In Report Filter Pivot Table But Dates Are Not Static

Pivot Table - Group Individual Dates Into Months

Bookmarks

Bookmarks

Posting Permissions