I'm struggling getting dates to load in a new import. We're using the same format as other imports that work fine so this is stumping me. The datafile is a .csv file saved from an Excel file. The data is formatted as 2/7/2018 and the control file has the date formatted as CREATION_DATE DATE 'MM/DD/YYYY'. It doesn't matter if the data is 02/07/2018 or 2/7/2018 I still get a ORA-01843: not a valid month. What am I missing?