Filter to show tasks from <today> onwards

[Peter Peterson]

Hi there,

Please please help. How can I create a filter (in project 2000) to only
show tasks that have either not completed or started. All my current views
are listing tasks that finished months ago. Many thanks inadvance.

Oliver

ps Let me know if you need any further information

 

[Peter Peterson]

Bugger! Nope it doesnt work if in a filter a put "today" as the value - it
does indeed insert todays date but permanently. So if I save the filter
today it will always have todays date as 03/09/2003 instead of being dynamic


Back to the drawing board!

Any ideas?

 

[Steve House]

You must be using Project 98. This has been fixed in later versions with a
date function that updates at run time.

 

[Peter Peterson]

No Project 2002

This is what I have put for my filter:

And/Or - Field Name - Test -
Value(s)
Resource Names equals Bob
AND Finish is greater than or...
today
AND Start is less than or...
sat 01/01/08

The problem is with the 2 date values - the last one isnt too bad as I can
just put that way in the future which is fine. But the one with today is
really annoying as it just gets converted to the date of editting - if i go
back in to edit the filter it wont be "today" anymore but that date

Thanks again so far!

 

[Steve House]

Try this - use Tools, Customize, Fields and create a user-defined task date
field that has its value the function Date(). This gets updated to the
current date with each recalculation of the project. Project recalculates
like Excel, an edit triggers it, but if you don't edit something you can
force the recalculation with F9. I'm not a Project VB guru but you could
probably trigger a recalculation on file open or on applying the filter by
using a couple of lines of VB as well. So let's say it's Date1 you use for
this field and you don't rename it. Modify your filter to read ...Finish >
= [Date1]... and that should do it.

 

[Peter Peterson]

Wahooo! Thanks very much Steve - great help! Fixed - sorted - done!

Cheers

Try this - use Tools, Customize, Fields and create a user-defined task date
field that has its value the function Date(). This gets updated to the
current date with each recalculation of the project. Project recalculates
like Excel, an edit triggers it, but if you don't edit something you can
force the recalculation with F9. I'm not a Project VB guru but you could
probably trigger a recalculation on file open or on applying the filter by
using a couple of lines of VB as well. So let's say it's Date1 you use for
this field and you don't rename it. Modify your filter to read ...Finish

= [Date1]... and that should do it.


--
Steve House
MS Project MVP
Visit http://www.mvps.org/project/faqs.htm for the FAQs

No Project 2002

This is what I have put for my filter:

And/Or - Field Name - Test -
Value(s)
Resource Names equals Bob
AND Finish is greater than or...
today
AND Start is less than or...
sat 01/01/08

The problem is with the 2 date values - the last one isnt too bad as I can
just put that way in the future which is fine. But the one with today is
really annoying as it just gets converted to the date of editting - if i go
back in to edit the filter it wont be "today" anymore but that date

Thanks again so far!

with value -
it 2000)

 

[Steve House]

By the way, instead of using the Date() function you could also set the date
field you select to be equal to the [Current Date] Project field. I think
this will let you avaoid having to force a recalculation on file open.

--
Steve House
MS Project MVP
Visit http://www.mvps.org/project/faqs.htm for the FAQs

Wahooo! Thanks very much Steve - great help! Fixed - sorted - done!

Cheers

Try this - use Tools, Customize, Fields and create a user-defined task date
field that has its value the function Date(). This gets updated to the
current date with each recalculation of the project. Project recalculates
like Excel, an edit triggers it, but if you don't edit something you can
force the recalculation with F9. I'm not a Project VB guru but you could
probably trigger a recalculation on file open or on applying the filter by
using a couple of lines of VB as well. So let's say it's Date1 you use for
this field and you don't rename it. Modify your filter to read ....Finish

= [Date1]... and that should do it.


--
Steve House
MS Project MVP
Visit http://www.mvps.org/project/faqs.htm for the FAQs

No Project 2002

This is what I have put for my filter:

And/Or - Field Name - Test -
Value(s)
Resource Names equals Bob
AND Finish is greater than or...
today
AND Start is less than or...
sat 01/01/08

The problem is with the 2 date values - the last one isnt too bad as I can
just put that way in the future which is fine. But the one with today is
really annoying as it just gets converted to the date of editting - if

i
go

back in to edit the filter it wont be "today" anymore but that date

Thanks again so far!

You must be using Project 98. This has been fixed in later versions with
a
date function that updates at run time.


--
Steve House
MS Project MVP
Visit http://www.mvps.org/project/faqs.htm for the FAQs


Bugger! Nope it doesnt work if in a filter a put "today" as the value -
it
does indeed insert todays date but permanently. So if I save the filter
today it will always have todays date as 03/09/2003 instead of being
dynamic


Back to the drawing board!

Any ideas?

Haha! Worked it out - simply using "today" as the function to give
todays
date. Simple!

Hi there,

Please please help. How can I create a filter (in project 2000)
to
only
show tasks that have either not completed or started. All my current
views
are listing tasks that finished months ago. Many thanks inadvance.

Oliver

ps Let me know if you need any further information

 

[LK]

If you have columns entitled Actual Start and Actual
Finish, you can find out by using the custom filter. Just
use the formula for either start or finish date of Equals
NA.

I hope that's what you were asking.