I have data where the date has the time
When I do a pivot table since the same dates have different times they can't be grouped or counted, I've tried changing the date format though no dice, any thoughts on how I clean this up?
Code:
4/3/2011 5:25:30AMWhen I do a pivot table since the same dates have different times they can't be grouped or counted, I've tried changing the date format though no dice, any thoughts on how I clean this up?
