I have a field in a table that is text in the format of yyyymmdd. I need to convert this data to a date format (mm/dd/yyyy).