anyone aware on a formula that will change a date column ie: 3/4/2006
to 1/1/2006, I have a pivot table that only recognizes that format.