Hi,

I have a sheet which I'm processing using Talend (Open source ETL tool) and trying to filter by date, in the Excel file every row appears to be in the required format (DD/MM/YYYY) however, when I add a filter to the sheet it appears like this -

+ 2011
+ May
+ 01
+ 02
+ 03... etc.
until 31 then continues with -
+ 01/04/2011
+ 01/05/2011 and so on.

Its quite a large sheet with > 31k rows.

I have tried to format the whole column as a date but it still appears like this when filtering.
I've stripped it down to just a few rows and the Talend job works fine.
I've processed similar files in Talend where I'm able to use the Excel filter to drill into year/month etc. without any problems.

How can I get the dates to filter as they should?

Cheers

Mark