Auto Filter

I am attempting to apply an custom AutoFilter to the duration field. I
select "is greater than or equal to" from the drop down list of the Custom
AutoFilter dialog box and "3d" - click OK and I get the message "This is not
a valid test. Click the test in the list, and then press ENTER." I don't get
this error if I select just "equals" or "is greater than" by itself.

Thanks in advance for your insights.

JulieD
Thu Mar 10 09:51:55 CST 2005

Hi

seems to work fine for me - now, isn't that helpful :)
what i'm doing is
1) in gantt chart view - click on autofilter icon to turn on drop down
arrows
2) click on drop down arrow for duration column
3) choose custom
4) choose is greater than or equal to in the first box of the first row
5) type
3d
in the second box of the first row
6) leave everything else blank
7) click OK

are you doing anything different?
what version etc?

Cheers
JulieD

"The Empowerment Group" <ccc_instructor@hotmail.com> wrote in message
news:zoVXd.118$qf2.5@newsread2.news.atl.earthlink.net...
>I am attempting to apply an custom AutoFilter to the duration field. I
> select "is greater than or equal to" from the drop down list of the Custom
> AutoFilter dialog box and "3d" - click OK and I get the message "This is
> not
> a valid test. Click the test in the list, and then press ENTER." I don't
> get
> this error if I select just "equals" or "is greater than" by itself.
>
> Thanks in advance for your insights.
>
>

JulieS
Thu Mar 10 10:07:02 CST 2005

Hi Empowerment Group,

Are you typing in the test or selecting it from the list of durations in the
Custom AutoFilter? If you are typing, are you adding the quotes around the
duration or just entering the number and measurement unit? If I type in "3d"
with the quotes, I get a message "The entry is not valid." However, typing in
the quotes shouldn't work for any filter in the duration field.

Hope this helps. Let us know how you get along.
Julie


"The Empowerment Group" wrote:

> I am attempting to apply an custom AutoFilter to the duration field. I
> select "is greater than or equal to" from the drop down list of the Custom
> AutoFilter dialog box and "3d" - click OK and I get the message "This is not
> a valid test. Click the test in the list, and then press ENTER." I don't get
> this error if I select just "equals" or "is greater than" by itself.
>
> Thanks in advance for your insights.
>
>
>