Effective due date

[Oren]

Hi All,
I am looking for command that will calculate the effective date of a predecessor which has lag or lead.
For example if I have a task that has a predecessor with finish date on December 7 and with lag of 3ed then the effective date of the predecessor is December 10 (in case of link type: finish to start).
Does anyone know what is the best way to write this?
Thanks

 

[John]

Oren,
Actually the best way to get the date in question is to simply query the
start date of the task. In other words, why not let Project calculate it
for you. For example, your task whose predecessor has a finish date of
12/7/2003 and a lag of 3ed will have a start date of 12/11/2003.

However, if you really want to determine the date yourself, I suggest
you use either the DateAdd or Date Subtract methods depending on whether
the predecessor modifier is lead or lag. You should also be aware that
you may likely get a slightly different actual value when you use the
DateAdd or DateSubtract methods. For example,

Temp = Application.DateAdd("12/7/2003 5:00:00 PM","3ed")

will give a Temp value of 12/10/2003 5:00:00 PM. This is because
12/10/2003 at 5:00 PM is exactly 3 days (elapsed or working) from
12/7/2003 at 5:00 PM. Depending on what you intend to do with the date
value you "calculate" you may need to employ a few extra "tricks" to
make things work as intended. Sometimes it is better to let Project do
the calculating.

Hope this helps.
John