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
Bookmarks