When using the import Table Data Feature I have a date that is not importing correctly using TOAD for Oracle 18.104.22.168. The dates loaded correctly using TOAD for Oracle 10.6. The format of the date in the spreadsheet is 122704. I chose Date Order Custom and then type mmddyy (as I did on 10.6). However, now the data loads as 12/13/2235, instead of 12/27/2004.
Waiting for fix to be released in a future version of Toad for Oracle.