Sometimes, I've changed the column with dates to be formatted as General.

Then did the filter and then later redid the formatting back to a nice date
format.

If that's too ugly, maybe you could insert a helper column and do the
equivalent.



chOcO wrote:

hi Dave,

tried changing the code but still the same. it's showing results as far
back as yr2003. My dates are entered in the dd/mm/yy format.

--

Dave Peterson