Trouble with Import Wizard - Date format
660746Feb 5 2009 — edited Feb 20 2009I am trying to import data from an excel file to a table using the Import Wizard. The verification of the import fails on the verification of the date column only, with the message that "Dater columns HOLIDAY_DATE, have invalid or null date formats"
There are no null / blanks in my xls file, and the date format in the xls file is dd/mm/yyyy. When this is imported through the import wizard, the date column shows the data, but the format shows the data in mm/dd/yyyy ??
Is there anything obvious I am doing wrong here?
Thx