Start date same as planned start date

[J_31]

I want to populate start date and end date based on planned start date and planned end date

run a fix script to update existing records in rm_sprint table , wrap this as a  function 

can someone help with code 

[Saurabh Gupta]

Hi,
You just want a copy or something else based on planned start date and planned end date?

[Anil Lande]

Can you please share what you did?

[Harish KM]

Hi @J_31 Find below script which maps planned start and end dates to  start and end dates

updateDate();
function updateDate(){
var rm= new GlideRecord('rm_sprint');
rm.addEncodedQuery('end_dateISNOTEMPTY^start_dateISNOTEMPTY'); // ensure planned end and start date are not empty
rm.orderBy('sys_created_on'); //order by created on
rm.query();
while (rm.next()){
rm.start=rm.start_date;// planned start date
rm.end = rm.end_date; // planned end date
rm.setWorkflow(false); //Do not run business rules
rm.autoSysFields(false); //Do not update system field
rm.update();
}
}