Reporting on PlannedCompletionDate Changes for Tracking

[MARIBELME1]

Hello! 

We are trying to setup a new custom field, or check if the system can provide this, to track the date that a project's planned completion date changed on, our goal is to be able to review logs of when these changes occur in a project.

Eventually we will want to use this field to provide updates in another fusion scenario that post an update in the project with what the date changed from, what it changed to, and when it changed so that we can historically track these changes. However, if we can export or report on specific system change information we would not need the Fusion scenario for this, so we'd like to see if it's possible without fusion. 

I was able to pull a report on plannedcompletiondate changes, however since our projects are setup by Start Date they aren't being captured because the changes are being driven by the task durations in the project template not changes made to the actual plannedcompletiondate. Due to Fusion scenarios we have setup for project creation, all Project Schedule Modes are set to By Start Date (not by completion date) and that cannot be changed. 

Any insight on how to report on these system changes based on projects scheduled by start date would be very helpful, any assitance is appreciated. 

Thank you!

[Richard_Le_]

Hi,

When you project is scheduled from Start Date, the planned completion date is automatically calculated by the system. It is calculated by adding the duration of all of your tasks to the start date.

The only way for the planned completion date to change is by changing the duration of your tasks, or adding new tasks. It is not possible to change the planned completion date manually for a project scheduled from start date.

Are you wanting to report on when tasks durations were changed to something different from the source template and/or additional tasks were added to the project since it's creation from a template?

Best Regards,

Rich.

[MARIBELME1]

Hi Rich,

Thanks for the reply! We are specifically wanting to track when the changes were made to the PlannedCompletionDate, I understand it's driven by ask durations/adding new tasks.

Is there a way to report on when a ProjectCompletionDate was changed with project schedule modes set to by Start Date?

for example:

X Flyer project plannedcompletiondate changed from 9/25/25 to 10/2/2025 on 9/23/2025

[Richard_Le_]

Hi,

Sorry for my slow response.

There are three possible solutions you could explore :

1. Using Fusion you could watch for changes to the plannedCompletionDate and have Fusion write the changes to a custom field as Surya mentioned in their suggestion above. If you don't have Fusion, you could . . .
2. Again, following Surya's suggestion, enable plannedCompletionDate as a tracked field so that changes this field are written to the system updates of every project. With this enabled, you could then use a Journal Entry Report to report on each time the date was changed and by whom. You can read more on Journal Entry Reports here. You can read more on tracking specific fields in update feeds here.
3. You could build a calculated field that tracks each time a change is made to the plannedCompletionDate. Take a look at this thread here which explains the text mode to use and the sort of output you can expect to see. You wont be able to report on this per se, but it will provide you with an audit trail of who made changes to the plannedCompletionDate and when, all in one location. Although the thread talks mostly to tracking status changes, changing the tracked field to plannedCompletionDate should work.

Hope this helps!

Best Regards,

Rich.

[SuryaLakhani]

Hello,

You can start by adding the Planned Completion date to the Update Feed. While this will not track the change, as you have mentioned, it will at least note when it was changed to a certain date. This would also record when PCD was changed due to a change in Duration.

For the use case you have, Fusion would be the only solution. If you create a webhook that watches updates to PCD for tasks, you can then add a field at the task level and record updates as logs in that text field. You should also be able to record who made that change.