Filter for "finish last week"

[nwlaura]

I wish to create a custome filter that shows tasks that were due to
finish "last week". Is there a way to setup something that
automatically calculates the date based on a Sun-Sat schedule?

thanks
nwlaura

 

[Jim Aksel]

Oddly enough [Status Date] is not understood by the filter wizards.
Instead, you can write a macro that will use either [Status Date] or the
[Current Date] and then add/subtract from that.

There may be an easier solution using the Status Column. The status column
provides information as "On Schedule", "Late", or "Future Task". You can
auto filter on any of these. This way, you will catch all out of date work.

You can also do a custom filter on [Finish] setting a min and max date.
However, this will not catch all work that is behind schedule... suppose it
is to start August 1st and finish October 1st and has 0% Complete. You
would want to know that too. See if [status] helps, or, write a macro
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[nwlaura]

Thanks for the heads-up and suggestions. I will try them and report
back.

 

[Gérard Ducouret]

nwlaura,

You could also add two custom fields : Start1 and Finish1 for ex, with the
formulas:
Start1 : ([Current Date]-Weekday([Current Date];2)-1)-5
Finish1 : [Current Date]-Weekday([Current Date];2)+1
These 2 formulas are designed for a week which starts on Monday. You will
have to adapt them for a week which starts on Sunday.
Then it easy to create a filter:
Finish... is within ... [Start1];[Finish1]

Hope this helps,

Gérard Ducouret

 

[nwlaura]

Gerard, many thanks. I will definitely let you know how this helps me!

Best,
Laura

 

[nwlaura]

I am having trouble finding anything to correlates to *[Current Date]*

Is there a function or formula for it?

 

[Gérard Ducouret]

nwlaura,

When you are customizing a field, in the formula editor: click A Field
button / Project / Date / Current date
Hope this helps,

Gérard

 

[nwlaura]

Ah, thank you! I was searching for it in Formula > Field > Date !!

I will try it soonand let you know results

Laura