Using DateDiff on separate line items

[troy_lee]

How can I calculate the date differential between a Start Date on one
line item and Start Date on the line item below it? Do I have to use
VBA for this or can I trick a custom field to do this? These are both
0D duration tasks.

Also, I need to delimit the loop by summary task. That is to say, when
I come to the next summary task, I want to skip that line and then
continue calculating the date differentials. Some summary tasks may
have 5 line items, some may have only two.

This is a simple schedule that shows the day something shipped and the
day it was received back at our facility for repair. Sometimes we
repaired a unit more than once, thus the need for multiple line items
for each summary task with each summary task being a serial number.

Thanks in advance for the help.

TL

 

[Jack Dahlgren]

You can not use a calculated field to compare values between tasks. You will
need a VBA macro to do it. Sorry. There are tricks about rolling up to
summaries... but nothing task to task.

-Jack Dahlgren
http://zo-d.com/blog