Quick Links

Reply To: Custom date formula

Home Forums Discussion Custom date formula Reply To: Custom date formula


Hey Clint;
Might I suggest that rather than messing with date formulas, you explore relationship with positive or negative lag values. This might be easier as it does not require the use of custom fields and date formulas. Meaning all milestones would show their appropriate start/finish dates using the standard MS Project fields. Additionally, if milestones are used for each, they can also be displayed n the Gantt timeline view to provide a better visual presentation.

So, for example, You could set up milestones for each of the events you noted with 0 work and duration. Then for example, DAD Submission would be a successor or Inaugural Construction but with a lag of -12W (meaning it occurs 12 weeks prior). Project Approval date would be a successor of DAD Submission with a positive lag of 6W (weeks).

If some of these relationships aren’t providing the correct results, you can also try a different twist on the relationships using a task constraint of As Late As possible.
For example, DAD Submission would be a predecessor of Inaugural Construction with positive lag of 12W but the DAD Submission would also contain a task constraint of As Late As Possible. This constraint causes the DAD milestone to be pushed as tight as possible up to the successor task but the 12w lag forces the constraint to honor the 12 week gap.

With these approaches, you may need to add the appropriate constraint to the Inaugural Construction milestone to ensure it occurs on 7/1 in your example. These constraints could be Must Finish or Start On, or Finish/Start On or After, depending on what else you have in the overall schedule.

Lag values can usually be entered where you assign predecessor/successor relationships.

With both these approaches, if the starting point (Inaugural) moves, all related milestones will move also!

Hope that helps