Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Need help to access Current Date filter on Microsoft Project

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-04-2010
Member
 
Join Date: May 2010
Posts: 65
Need help to access Current Date filter on Microsoft Project

I need some help to work with Project 2007. I am not able to setup a filter on the same that can allow me to view a set of task that has finished at interval of 30 days. In that what are the possible ways available through which I can simply access current date and configure filters on it. It would allow me to get more details on the older task and calculate a time difference.

Reply With Quote
  #2  
Old 26-05-2010
Member
 
Join Date: May 2010
Posts: 1
There is on Current Date field provided. So that is the reason you cannot get any ste of filter for the same. But you can do one thing. You can try to add custom date that might work and set the formula as per your choice. You can start working with a filter with the help of date field and you can then add the value in the same. Try the same and then provide information what error you got or you had able to get right result.
Reply With Quote
  #3  
Old 26-05-2010
Member
 
Join Date: Sep 2004
Posts: 105
re: Need help to access Current Date filter on Microsoft Project

Julie's proposal will work just fine. I might propose a slightly different approach:

1) Take a spare Duration field and add the following formula: ProjDateDiff([Current Date],[Finish],[Task Calendar GUID]) - this will calculate the difference between the Current Date and the Finish date for the task. Swap out Baseline Finish for Finish if required.

2) Create a new Group (Project > Group By), that groups by the custom Duration field. Set the intervals to 30.

That should do it. You may want to filter out completed tasks using a filter (Project > Filter for).
Reply With Quote
  #4  
Old 23-03-2012
Member
 
Join Date: Mar 2012
Posts: 3
re: Need help to access Current Date filter on Microsoft Project

[quote=JulieS;4906035]The [Current Date] field is not available in the value choice
options for custom filters. However, you could add a custom date
field (Date10 for example) and set the formula for that field as
[Current date].

Then create the filters using the date field as the value.



I tried creating a formula for current date as described above but there was a syntax error. can you please provide the specific formula. thanks.
Reply With Quote
  #5  
Old 23-03-2012
Member
 
Join Date: Dec 2006
Posts: 489
re: Need help to access Current Date filter on Microsoft Project

The formula is:

[Current Date]

no equal sign and field name enclosed in square brackets.

What did you enter?
Reply With Quote
  #6  
Old 23-03-2012
Member
 
Join Date: Mar 2012
Posts: 3
re: Need help to access Current Date filter on Microsoft Project

I entered date 5 = [Current date]
Reply With Quote
  #7  
Old 23-03-2012
Member
 
Join Date: Mar 2012
Posts: 3
re: Need help to access Current Date filter on Microsoft Project

Thanks Juile it worked fine.

How do I show incomplete tasks due in 5 days from current Date? thanks.
Reply With Quote
  #8  
Old 24-03-2012
Member
 
Join Date: Dec 2006
Posts: 489
re: Need help to access Current Date filter on Microsoft Project

You're welcome and thanks for the feedback.

Have you looked at the built in Date Range filter? It allow you to specify and start and finish date dynamically.

To get the current date + 5 working days - change your Date5 formula to:

DateAdd("d",5,[Start])

Julie
Reply With Quote
  #9  
Old 27-03-2012
Member
 
Join Date: Mar 2010
Posts: 57
re: Need help to access Current Date filter on Microsoft Project

This is great! I will try both suggestions since I currently run the "Should start/finish by" filter, put in the dates for 30, then 60, then 90 days from now. Then I have to go through and manually weed out the 30 dayers from the 60-day list and the 30 and 60 dayers from the 90-day list with another filter. Luckily my schedules are fairly short and statused frequently enough that there aren't many each time.
This will definitely be easier!
Reply With Quote
  #10  
Old 27-03-2012
Member
 
Join Date: Dec 2006
Posts: 489
re: Need help to access Current Date filter on Microsoft Project

Have you thought about using grouping on the date fields? You can set intervals to see your tasks grouped by day or by week
Reply With Quote
  #11  
Old 30-03-2012
Member
 
Join Date: Mar 2010
Posts: 57
re: Need help to access Current Date filter on Microsoft Project

That is so easy! You should write a book! You always have the best ideas.
Reply With Quote
  #12  
Old 30-03-2012
Member
 
Join Date: Dec 2006
Posts: 489
re: Need help to access Current Date filter on Microsoft Project

Thanks very much for your enthusiastic feedback. I actually have written a book about MS Project as well as MS Project and Clarity. Sadly, they were for clients so they are not available at your favorite bookstore.
Reply With Quote
  #13  
Old 30-03-2012
Member
 
Join Date: Mar 2010
Posts: 57
re: Need help to access Current Date filter on Microsoft Project

Bummer.
I'm actually looking for a book to improve my skills. I have no idea what all Project can do even though I've been using it for three years now.

It's funny how other people post questions that I have been pondering, too.

I was looking in the Kindle store yesterday, but they have so few. They are so expensive, too, so I don't want to buy one and find out it's garbage.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need help to access Current Date filter on Microsoft Project"
Thread Thread Starter Forum Replies Last Post
Rather than showing current date / calendar month, Microsoft calendar gadget is displaying a blank page Mustaffa Windows Software 5 23-04-2011 11:19 PM
How to add SilverLight 3 on current ASP.NET 2.0 web project. Andre Patton Technology & Internet 4 18-04-2011 08:55 PM
How to cross-site access to Microsoft Project? Miquel Windows Software 3 11-11-2010 01:25 AM
MS Project 2007 Current date column shoppingboy Windows Software 3 21-05-2010 01:40 AM
Getting Current Date in Java Level8 Software Development 5 27-02-2010 05:26 PM


All times are GMT +5.5. The time now is 09:04 AM.