date mask in SQL*Loader

I'm using SQL*Loader with a delimited file from Excel. I have a date field that the users are 'supposed' to populate with a format of 'mmddyyyy', and I simply do a to_date(:date_field,'MMDDRRRR') in the lod script and all is well.

However, very often I get dates in the file with a format of 'M/D/YYYY' or 'MM/DD/YYYY', and rather then reject that record during load, I would of course like to load it anyway.

Any suggestions on how to do this?

Tim Received on Fri Feb 09 2007 - 10:17:33 CST