Current Date
in [Project]
|
From: External Update on 14 Apr 2010 14:43 I am using Project 2007. I need to set up a filter that shows tasks that should finish within the next 30 days, 60 days, or 90 days. How do you access the current date to setup the filters. Thanks for your help. Lefty
From: JulieS on 14 Apr 2010 14:57 Hi Lefty, 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 hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project On 4/14/2010 2:43 PM, External Update wrote: > I am using Project 2007. I need to set up a filter that shows tasks that > should finish within the next 30 days, 60 days, or 90 days. How do you access > the current date to setup the filters. > > Thanks for your help. > Lefty
From: External Update on 14 Apr 2010 16:04 Julie, I tried your suggestion and it worked. I really appreciate the quick response. Thanks again. Lefty "JulieS" wrote: > Hi Lefty, > > 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 hope this helps. Let us know how you get along. > > Julie > Project MVP > > Visit http://project.mvps.org/ for the FAQs and additional > information about Microsoft Project > > On 4/14/2010 2:43 PM, External Update wrote: > > I am using Project 2007. I need to set up a filter that shows tasks that > > should finish within the next 30 days, 60 days, or 90 days. How do you access > > the current date to setup the filters. > > > > Thanks for your help. > > Lefty > . >
From: JulieS on 14 Apr 2010 16:43 You're most welcome, Lefty. Glad to have helped and thanks for the feedback. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project On 4/14/2010 4:04 PM, External Update wrote: > Julie, > > I tried your suggestion and it worked. I really appreciate the quick > response. > Thanks again. > Lefty > > "JulieS" wrote: > >> Hi Lefty, >> >> 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 hope this helps. Let us know how you get along. >> >> Julie >> Project MVP >> >> Visit http://project.mvps.org/ for the FAQs and additional >> information about Microsoft Project >> >> On 4/14/2010 2:43 PM, External Update wrote: >>> I am using Project 2007. I need to set up a filter that shows tasks that >>> should finish within the next 30 days, 60 days, or 90 days. How do you access >>> the current date to setup the filters. >>> >>> Thanks for your help. >>> Lefty >> . >>
|
Pages: 1 Prev: Resource units Next: Remove Time from Start/Finish Date Columns When Exporting toExcel |