Pivot Table Select Date

[Littlemalky]

I have a workbook with multiple tabs. One of the tabs is designated for pivot tables, in which there are multiple. I need the code to refresh all the pivot tables.

Secondly, under one of the 4 report filters on one of the pivots, I need to check the most recent date. This particular filter is entitled "RAW PROD ND DATE" and the drop down gives a bunch of dates. So the only one i need to filter is the most recent date formatted mm/dd/yy.

How do I do this?

 

[Littlemalky]

The refresh code works great now. Thank you so much. Do you have any idea how to macro the report filter so that it filters only the most current date that shows in the drop down.