Excel 2007 stores its dates using a numeric representation that doesn't convey a particular format. Take the following spreadsheet as an example.
|A Spreadsheet Using Different Date Formats|
|Excel Metadata in Talend Open Studio|
|Mixed Settings for Handling Excel Metadata|
|Examining a tExcelFileInput Run|
For flexible Jobs, treat dates as dates throughout your Talend Job. RDBMS have different default formats and you'd like to avoid conversions in your SQL (like Oracle TO_DATE functions). If the date format is important, it's best to tackle this at the source. Excel 2007 can save a spreadsheet as a delimited file that will preserve the dates exactly as they're seen on the screen.