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).
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):
Member for
11 yearsThanks for the tip. This
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).
Member for
18 years 11 monthsThe hard part of your
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=2…
Obviously, this may need a little tweek to fix the year-end issue (and to exclude summary tasks, etc.)
Good luck, tom