Date with Autofilter

D

David C.

Hello,

here is my problem

in a column, I've got dates... let's say 08-18-2004 for example
(18th august, 2004 )

the header of this column is in "AUTOFILTER" and if I look for a date wich
is

equal or greater than 08-18-2004
it's ok it shows my line

but if I ask for "equal to..."
then... the line is not shown !!! This is not supposed to happend...

I'm looking for a solution (how to use the equal possibility for only one
date )
thx
 
F

Frank Kabel

Hi
any chance your date values also contain a time
information (and are just formated to show only the date
part)?
 
D

David C.

any chance your date values also contain a time

very good idea... but :) not the right one...
the hour is 0 and the date is just a date... :-(

My actual thinking is the autofilter look for a string (not a date).
But I'm not sure, and whatever I still don't know how to solve that
 
D

Dave Peterson

Until you find the reason (I don't have a guess), maybe you could use:

greater than 08-17-2004
and
less than 08-19-2004

And you did clear out that second criteria, right?
(or even do a Data|filter|showall)

And what happens when you just select that date from the dropdown--don't use
custom at all?
 
D

David C.

Until you find the reason (I don't have a guess), maybe you could use:
greater than 08-17-2004
and
less than 08-19-2004
Click to expand...

It seems to be a bug (known in non english versions)
the equal doesn't works (greater or less than are ok)
And what happens when you just select that date from the dropdown--don't use
custom at all?
Click to expand...

This was not the point, because I was looking for customization.
But a bug is a bug...
 
D

Dave Peterson

I was just curious about using the dropdown.

David C. said:
It seems to be a bug (known in non english versions)
the equal doesn't works (greater or less than are ok)


This was not the point, because I was looking for customization.
But a bug is a bug...
Click to expand...
 
Top