I have a data set that has a column with date of service in the format of
mm/dd/yy. I would like to be able to pivot my data set based on mm/yy. Is
there a way I can convert from one format to other without manually inputting
the new column. I know I can reformat my column to appear as I wish, however
the pivot fuction still reads each day as its own data set.

Ex:

I have...12/06/06
I want...Dec-06
and pivot to show Dec-06, Jan-07, Feb-07, etc. for the rest of the rows as
appropriate.