"last week" custom filter for start column

[jmac60]

start & finish columns have auto filters have 'today', 'tomorrow',
'next week', etc.
Does anyone know how to create 'last week' so I can quickly filter on what
should have started last week in status meetings?

I can not get what I want using combinations of canned filters.

Thanks
John

 

[Jim Aksel]

You may want to start with a copy of the Date Range filter.
To create a new filter, Projetc/Filters/More Filters.... select either new
or copy.
Give the filter a name and select the check box so it appears in the menu.
I am suggesting you start with a copy of the date range filter because it
shows you how to input a variable date.

Your constraints are
Start >= "Enter First Work Day of Last Week"
AND Start<="Enter last work day of last week"

The filte would then be accessed from the Project/Filters menu while in the
meeting.
--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com

 

[jmac60]

thanks, Jim...
your solution does work...I am trying to avoid entering dates and employ the
same logic used to create this week & next week filters, allowing the last
week filter to float. too bad.

 

[Jim Aksel]

It would be nice if the variable [Status Date] was available in the drop down
when you specifiy the criteria on the filter. That would avoid manually
keying the date.

You can circumvent all that and create your own filter with a VBA Macro
specifyng the status date. You would then key off that date less 5 days.
Unfortunately, adding it to the drop down exposed by the AutoFilters is not a
feature available in the API that I have located. Thank you for the feedback.
--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com