Filtered views??

[dave]

Recently, I've tried to use the Fliter (optional) feature in PWA "manage
views" . I've built up a view called Late Unstared Started Tasks. I've
setup up the following fields in that view;
Task name,
Start,
Actual Start,
Baseline Start.

I want a filter to list all the tasks which have a Baseline Start less than
the current date and an Actual Start which equals NA (because the tasks
hasn't been started)

SO... I've tested it out using the following
Baseline Start--- Equals --- a date (which has been manually entered) And
Actual Start ---- Equals ----NA
click Save
and attempt to activate the view. The view fails.
When you return to the "manage views" modify, the value of NA has been
replaced with 6/8/2162

I've tried entering the NA as "NA" but that leds to a error message and
cannot be saved.
Ideally, I would like to fix this filter.
But I would also like the Value for "Baseline Start" to equal [Now] or
Current start date of the project Any ideas would be appreciated.

Help Dave

 

[Gary Chefetz [MVP]]

Dave:

Just because the application displays "NA" doesn't mean that's the value
stored in the database. Blank dates have the value of NULL in SQL. Try
testing for a Null value.

--
Gary Chefetz [MVP]
http://www.msprojectexperts.com

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.