Re: Assignments Starting Before Today?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thank's John,

Occam's razor does it again!

However, although the Value(s) column of the Filter Definition dialog box
will accept "today", it converts it to the actual date of when the filter was
created. When I want to see the corresponding information tomorrow, next
week, or next month, the filter is still set for the old date. Using a
function in a date field is reset to the current date any time the project is
calculated.

Any other suggestions?

"John" wrote:

In article <8274DF96-64E6-4B32-B0BD-1A6AB9DC5760@xxxxxxxxxxxxx>,
Robert <Robert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I'm trying tio filter a Resource Usage view for Assignments that should have
started but are incomplete. Setting % Work Complete < 100% is easy. The
date in the filter is a problem.

Using a spare Resource date field, I've used Now(), Date() and
DateValue(Now()). All set the value of the Resource field to Today - but not
the Assignment field. Subsequently, the filter fails.

I'm not looking for just Tasks and I'm not looking assignments "in-progress"
or "incomplete".

Any suggestions will be appreciated.

Robert

Robert
I'm a little unclear on what you've done with the spare date field.
Please elaborate.

In fact, why are you using a spare field at all? Why not just use the
Start field in the filter test - something like the following:
And/Or Field Name Test Value
% Work Complete is less than 100
And Start is less than or equal to Today

By the way, I'm not sure that you are asking what you really want. Tasks
that should have started may or may not be complete depending on when
they are scheduled to finish. Your use of the word "incomplete" makes me
wonder if you mean what you say.

John
Project MVP

.

Relevant Pages

  • Re: Deleting rows based on column values
    ... Try on a spare copy ... Repeat to filter again by the next criteria set> delete ... ... entire cols before clicking Data> Filter> Autofilter. ...
    (microsoft.public.excel.newusers)
  • Re: Assignments Starting Before Today?
    ... Using a spare Resource date field, I've used Now, Dateand ... the Assignment field. ... Subsequently, the filter fails. ... I'm a little unclear on what you've done with the spare date field. ...
    (microsoft.public.project)
  • Re: Deleting rows based on column values
    ... One way is via Autofilter ... Try on a spare copy ... Repeat to filter again by the next criteria set> delete ... ...
    (microsoft.public.excel.newusers)
  • Re: Current Date
    ... Harry wrote: ... You could use the Today function but as soon as the filter is applied, ... Your best bet is to use a spare date field and customize it by setting ...
    (microsoft.public.project)
  • Re: Sorting a subset of tasks not the whole project
    ... Develop a filter to segregate the subset of tasks you want sorted and ... re-sort the file in ascending order on the spare number field ... Note that the above process will not segregate the subset of tasks (not ...
    (microsoft.public.project)