Filter pivot by date

I need to figure out how to filter the pivot table in the attachment by the Posted date. I only want to look at the data for dates within 30 days of today, and can't figure out how to do that manually, much less programatically. The attachement is a small sample of a huge report I receive; all I get is the pivot, which contains tons of information. I filter it down by my various criteria, but that's still hundreds of thousands of lines. Limiting to the last 30 days can make a huge difference, but I can't find the trick to it. Any help is greatly appreciated.

Thanks,
John

Ernest,
Apparently, YOU ROCK!. I'm testing it, and so far it hasn't failed. I'll update again once I'm thoroughly convinced. Thanks for teachming me the CDATE function; I wasn't aware of that one.

I hate it when a good solution doesn't want to work for me. Below is how I tried to use the code. I'm getting an error 13 when I run it now. Any ideas?

Please Login or Register  to view this content.

That's what I had in the original attachment, and for that data set the macro worked fine. Now when I try it on the actual workbook I get the error 13. I thought I might have plumbed it into my existing code wrong, so tried the code as shown below. I got the same error. The error is occuring on the CDate line:

Please Login or Register  to view this content.

Here's the code as implemented this last time:

Please Login or Register  to view this content.

Type mismatch

Done. Original file in xlsm format.

Sure, attached, but in the attachment the macro works. I can't upload my full pivot, as the file is huge. So I have to select some data, doubleclick, delete about 40 columns of data and about 300K rows to create something small enough to attach, and build a pivot from that that vaguely resembles my original data set.

Trifecta. I got the Error 13 on all three tries. Here's how I did each one:

Please Login or Register  to view this content.

So then I thought, why not take out the CDate altogether? So I did this:

Please Login or Register  to view this content.

No error! But.... the result isn't what I expect. Looking at 2012, 2013, and 2014, January and October are turned off, some of November is turned off, but I have 12 and 13 on for all other results (in other words, Feb 2012 is on, when I want it off).

That's part of the problem; I have access to the pivot, not to the raw data. The dataset is too large to pull in all the detail, so I'm stuck with trying to work with the pivot table, not the raw data.

Still getting a type mismatch. Also, doing your date check, the results are FALSE, so it's text dates.

Actually, the Pivot is the pared down version of the file I get. Sheet2 is a pared down version of the data I can pull from my original pivot table, which I then used to build the pivot in the workbook.

It seems that the subject dates are text dates, but so are the dates in my example file. So why does the code work on one and not the other? I'm about to leave for the day, so probably won't be able to respond until tomorrow. I appreciate all the help you've given so far.

Sorry I didn't get back to you yesterday. I understand the concept, but we have an issue with saving the log file; the folder is protected, so I can't save a document in it. Can we save the log file to my desktop instead?

Okay, changed by adding the below section:

Please Login or Register  to view this content.

Result was a valid file, containing only these two lines:

Please Login or Register  to view this content.

Yes, except that it left blanks in. I revamped your code slightly to turn off whatever isn't a date, and that appears to be working. Please let me know if you see any problems with the way I've changed it.

Please Login or Register  to view this content.

Since I really don't need to log my errors, because the blanks are going to show up every time, I think we can make it even shorter:

Please Login or Register  to view this content.

That should work, shouldn't it?

That's a good thought. No sense in reinventing the wheel, is there?

Thanks for all your help on this.