Can I get someone else to confirm this before I submit it to RBTI? I'm trying to import an Excel XLS file using File Gateway in eXtreme 9.0, ver. 9.0.1.11111. The Excel file has a date column and the dates are entered as mm/dd/yyyy but formatted to display as 'day month year' (i.e. 20 Jan 2009) . I have changed the gateway setting to DMY but the date data does not import (actually tried all options for format). If I change the format of the Excel column to mm/dd/yyyy it imports correctly.
Could someone please test this for me before I submit it? It's very likely I'm just missing something. I've also tried this in the latest V8 build and get the same results. Thanks in advance, Paul Buckley
