Problem filtering by data 12/01/2002
Hi ,
I have data in 13 columns and the second column contains the "start dates".
The "start dates" are in the following format "26/09/2007" etc. [UK Date
format].
I need to filter for dates greater than "12/01/2002". So far I have been
unsuccessful. I have tried to reformat the "start date" column as date and as
text but I still cannot filter for "greater than" via the autofilter.
"12/01/2002" is not an actual date in the " start date" column.
I don't mind if I have to use a macro to get the required result.
Thanks
|