Prev: User defined fields and graphical indicator reporting
Next: Can't See Status Reports Filed
From: laskater on 12 May 2008 17:58
I am trying to use a custom filter in a resource assignments view to only
show assignments that have a start date on or before the end of next week. I
can create a filter for start dates on or before today ("start is equal to or
greater than TODAY"), but I don't know how to include the next week. "TODAY
+ 7" does not work. Is this something I can do?
From: Mike Glen on 13 May 2008 03:32
Hi laskater,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP



"" <laskater(a)discussions.microsoft.com> wrote in message
news:D14883B0-F42E-42EC-AC14-FB0277076F2B(a)microsoft.com...
>I am trying to use a custom filter in a resource assignments view to only
> show assignments that have a start date on or before the end of next week.
> I
> can create a filter for start dates on or before today ("start is equal to
> or
> greater than TODAY"), but I don't know how to include the next week.
> "TODAY
> + 7" does not work. Is this something I can do?



From: Trevor Rabey on 13 May 2008 22:36
The Filter must be able to look at a field.

Try using a couple of spare date fields.
In one of them, make a formula for today. Use the NOW() function.
In another, make a formula for NOW() + 7.
While you're at it, use another for the Status Date. Status Date() is a
function.

Then make a filter which can find tasks which are between NOW and NOW + 7.
You need tasks for which either the start or the finish are between NOW and
NOW + 7.
You also need tasks whose start is before the window and whose finish is
beyond the window.
It is easier to filter out the tasks you don't want than to filter in the
tasks that you do want.
Here is the filter:
Finish is not less than now
and
Start is not greater than now + 7

lo and behold, this is the same thing as the built in Date Range Filter.
The Date Range Filter gets its dates from user input but you can copy the
Date Range Filter and adjust the copy to get its dates from the fields.
Make sure you name the new filter something like "AA 7 day window from now".
The "AA.." helps you to find it at the top of the list.

Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au
"laskater" <laskater(a)discussions.microsoft.com> wrote in message
news:D14883B0-F42E-42EC-AC14-FB0277076F2B(a)microsoft.com...
>I am trying to use a custom filter in a resource assignments view to only
> show assignments that have a start date on or before the end of next week.
> I
> can create a filter for start dates on or before today ("start is equal to
> or
> greater than TODAY"), but I don't know how to include the next week.
> "TODAY
> + 7" does not work. Is this something I can do?


 | 
Pages: 1
Prev: User defined fields and graphical indicator reporting
Next: Can't See Status Reports Filed