Using Custom Filters and Wildcards in Project Server 2003?

[dwhite]

I am trying to build a customer filter to track "current" (as appears on
tasks page), or "in process" (same filter that is in client version of
project) tasks. In order to build the filter in server, you would need to
include the following formulas:

{Actual Start} {Does Not Equal} {NA} And,
{Actual Finish} {Equals} {NA}

I get an error message when I use "NA". There is a message in server that
says to use Wildcards (% and _) when searching text fields, while this is not
a text field I did try this, still no luck.

Any thoughts on how to create this filter.

The Built-In filter "Current" vs. "All Tasks" that appears on the Tasks page
would be great, if only I could get that filter for the Project plan page.

 

[Reid McTaggart]

Instead of testing for the value "NA" try testing for length of the string is
less than 3. That's the approach we use when we write formulas that test
date values in PPro, so maybe it will work for you on the server.

 

[dwhite]

Thanks for the suggestion. Unfortunately, that did not do the trick. When i
put a number in the test field, it automatically enters in a date for current
month; for example, if I enter "3", it automatically make the value of the
test field "7/3/2005".

 

[Reid McTaggart]

Well, I'm out of my league here, but why do you have to put 3 into a field?
Why not just test the length of the date string and hardcode the 3 into the
formula? Something like: LEN(STR({Actual Start})) {Less Than} 3

Or, if you must put the 3 into a field, why not put it into a number field
instead of a date field?