I was wondering if anyone knew if it were possible to use the GETPIVOTDATA() Function to import the text/date strings of a particular row that correspond to a part number? I know you can use it to import the values (sum, count, total of, etc...) But, I just want to import a specific field with a date for a part number.

Scratch that, it was just easier to add a max value to show the date in the pivot report.