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

[BrokenDome]

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]

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.