How would I create a calculation with date dependencies on other records within the same table. Calculation would be in ex: field cActual Date
Phase / Orig Date / InputStart Date / cActual Date
Example Record Scenario:
Phase orig Date InputStart Date cActual Date
Phase 1 6/1/16 (empty) 6/1/16
Phase 2 6/5/16 6/15/16 6/15/16
Phase 3 6/10/16 (empty) 6/16/16
The concept is to have preset dates for "orig Date" field. "InputStart Date" field will be an input by user if the orig Date should change.
Phase 2 will be based on # days beyond Phase 1 "cActualDate". Phase 3 is dependent on resulting 1 day after Phase 2 "cActual Date" field.
Dependencies of phases will not always be consecutive ie: Phase 2 to 1 and Phase 3 to 2. Example, Phase 10 could be dependent on date in Phase 2.
Hope this makes sense.