Assignments Starting Before Today?

[Robert]

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

 

[John]

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

 

[Robert]

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]

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?

Robert,
Sorry I'm not savvy with respect to "occam's razor" (i.e. I have no idea
what that is). So color me dumb.

You're right about using the "today" function in a filter - it gets
fixed at the current date. Unfortunately, spare resource fields are not
customizable (i.e. no formulas) so there is no easy way to set up the
filter you want. It is possible with VBA, or you could use a filter
similar to what I suggested and manually update the date - not real
convenient but it will get you there.

John
Project MVP