Planned Strat &end dates issue in the change request.

[Sidhu9]

My Requirement is an Updated Planned start and date in the Change request, But this date is not updated in the List of Change Tasks view, showing only the Previous date and time. It is not showing the latest date and time. Example: updated screenshots Please check once.

Thanks 

Srinivas

[AnveshKumar M · Accepted solution]

Hi @Sidhu9 ,

You can write BR on change_request table like the one below, with the following script.

(function executeRule(current, previous /*null when async*/) {

	var ctGr = new GlideRecord('change_task');
	ctGr.addQuery('change_request', current.getUniqueValue());
	ctGr.query();

	while(ctGr.next()){
		ctGr.planned_start_date = current.start_date;
		ctGr.planned_end_date = current.end_date;
		ctGr.update();
	}

})(current, previous);