ARCS-TM Data Management Supported date format is dd-MMM-yy ERROR

Summary

using CDM a source date of mm/dd/yyyy is failing to load with error of Supported date format is dd-MMM-yy.

Content

Using CDM a source date of mm/dd/yyyy is failing to load with error of Supported date format is dd-MMM-yy.

Is there a way in either ARCS or CDM to:

1. In ARCS, change the Attribute Date to be mm/dd/yyyy instead of dd-MMM-yy

OR

2. In CDM, to convert the date from mm/dd/yyyy to dd-MMM-yy.   I tried creating it s a GENERIC instead of ATRIBUTE and then assigning a MAP Member #SQL formula of:   TO_CHAR(TO_DATE(ATTR5, 'mm/dd/yyyy'),'dd-MON-yy') but that did not work either.