Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Flag New Tasks Starting Next Week MSP 2010

2 replies [Last post]
Thu, 2015-11-19 22:23
Lee Wilson
User offline. Last seen 5 years 52 weeks ago. Offline
Joined: 8 Nov 2014
Posts: 3
Groups: None

Hi All,

As title suggests I'm looking to implement a new flag to show tasks (excluding group headers) which are due to start the next working week.

I don't want to show any tasks currently in progress, jut new ones starting next working week.

Any ideas ?

Thanks

Top

Replies

Mon, 2015-11-23 21:38
#1
Lee Wilson
User offline. Last seen 5 years 52 weeks ago. Offline
Joined: 8 Nov 2014
Posts: 3
Groups: None

Thanks for the tip. This appears to work just as requested. I presume when we move into the new calendar year  - past the described week 52 into week 1 issue, then things return to normal. If thats the case then there is no issue as nothing happens for us in week 52-1 inclusive, due to Christmas furlough (exception in place). 

Top
Fri, 2015-11-20 04:16
#2
Tom Boyle
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

The hard part of your question is the "next working week" interval.  Fortunately, MSP allows the Datepart function from vba in custom field formulas, and with that we can get calendar-year week numbers.  Then we just want to trigger the flag for all tasks starting this year and starting in the week numbered one higher than the one we are in.  This seems to work except at the end of the year (the week no. 52/53/1 transition).  Apply this formula in a custom flag field:

IIf(Datepart("yyyy",[Start],2,2)=Datepart("yyyy",Now(),2,2) And Datepart("ww",[Start],2,2)=Datepart("ww",Now(),2,2)+1,"Yes","No")

You can refer to this document for fine adjustments to your work week interval and week numbering standard (the 2,2 in the formula):

https://msdn.microsoft.com/en-us/library/20ee97hz%28v=vs.90%29.aspx?f=255&MSPPError=-2147217396

 

Obviously, this may need a little tweek to fix the year-end issue (and to exclude summary tasks, etc.)

Good luck, tom

Top