Excel Dates - VisualCron - Forum

Community forum

thomasdaugharty@me.com
2011-02-23T20:04:11Z
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"
Scroll to Top