Hi,

I have a .csv file that I copy into and worksheet and use it for pivot
tables. The problem is that I need to remove the timestamp from the
date so I don't have multiple dates in the pivot dropdowns. I also
need to be able to sort on the date.

I tried picking the field apart with the left and mid functions, but it
will not sort as a date.

Any help would be greatly appreciated.

Thanks