| Project Name | Deliverable Name | Task Name | Planned Start | Duration | Planned Finish | Deliverable Planned Start | Deliverable Planned Finish |
| Project 1 | Deliverable 1 | Task A | 04/26/22 | 3 | 04/28/22 | 04/26/22 (?) | 05/04/22 (?) |
| Project 1 | Deliverable 1 | Task B | 04/29/22 | 5 | 05/03/22 | 04/26/22 (?) | 05/04/22 (?) |
| Project 1 | Deliverable 1 | Task C | 05/04/22 | 1 | 05/04/22 | 04/26/22 (?) | 05/04/22 (?) |
This is in a task table called DBID_NEW_TASKS
Project Name = field 49
Deliverable Name = field 7
Planned Start = field 20
Planned Finish = field 22
Is Start Milestone = field 23
Is Finish Milestone = field 64
What I tried and failed with for Deliverable Planned Start:
SumValues(GetRecord(ToDate("{7.EX.'"&[Deliverable Name]&"'}AND{49.EX.'"&[Project Name]&"'} AND{23.EX.'TRUE'}"), [_DBID_NEW_TASKS]), 20)
Any help or suggestions on how best I get this working? Thank you in advance.
------------------------------
Alan Rasmussen
------------------------------