Aaargh! Thank you Hui. I tried, and tried, and tried to get this to work; Gave up and searched for an answer; Gave up and posted a question here.
Here's what was wrong: My "Expiration Date" was DATEADD(d,DaysToExpire,TrainingDate). Apparently, this is returned as a string, and not a date. As...
I am trying to create a pivot table to display training records. I'd like the pivot table to display expiration dates for each training. (Preferably, the MAX date since the employee may have taken a training multiple times) I would like it to look something like this...