Planned end date calculation issue on certain Projects

Kristen Dettman
Kilo Sage
Kilo Sage

I need some help figuring out how the Planned end date is being calculated for some of the projects in our environments. It's my understanding that for projects without an Actual start date (i.e. those in a Pending state), the Planned end date is the Planned start date plus the Planned duration. However, once the Actual start date is populated and the project moves to Work in Progress, the Planned end date is then the ACTUAL start date plus the Planned duration. That is the case for most of our projects, but we're seeing some where the Planned end date is still being populated based on the Planned start date, even when an Actual start date is present. We're not seeing a consistent experience but can't figure out what differs between the projects. We haven't customized the Calculate End Date From Duration client script at all. Has anyone else come across this issue, or do you have any thoughts on what could cause this? I have attached an example of a project calculating this way.

 

2024-01-31_12-25-22.png

1 REPLY 1

Vinod54
Tera Expert

Hello @Kristen Dettman ,
Hope this answer still adds value to you or someone. 
I faced similar problem, found that there is a Recalculation Business rule which recalculates dates on planned_task table using a script include, find the below SN KB article which gives a detailed explanation. 

 

 
And also if you want to skip this recalculation for a certain table, ServiceNow has provided an exclusion table, where you can create a record for the table which you want to exclude the recalculation. 
 
If it helps, please click Helpful Icon. 
 
Thanks,
Vinod Kumar M