I have a character field with a date stored in it in the following format

mm/dd/yy

I need to get this to be in this format ccyymmdd

any suggestions?