Need the ability with the Excel converstion task to export dates with a date mask
example: 1/01/1900, mm/dd/yyyy OR 1900-JAN-01, yyyy-mmm-dd OR ...
Today these are exported as serial dates. Does not work with db utilities like SQL*Loader, bcp, etc
In excel if you click 'SaveAs' and write to CSV, the date fields come across in the masked format as seen in the excel document i.e 1/01/1900
Example Output
"data1","data2","01/01/1900"