Take value date/time from table change task and put in field in change request

[Yahav Mor]

When I have a task   I need to take  from field Expected start

the time and date 

and put in the field work start in change request

 and if I have a new task the field  work start is  change to the new Expected start

[Prashant Ahire · Accepted solution]

Hello @Yahav Mor  
Write a Business rule on change_task table which will be triggered whenever the new task is created.

When to Run: After Inster

Advanced:

    var gr = new GlideRecord("change");
    gr.addQuery("sys_id", current.change_request);
    gr.query();
    while (gr.next()) {
        gr.work_start = current.expected_start; //verify the field names
        gr.update();
    }

Please check and Mark Correct and Helpful if it really helps you.
Regards,
Prashant Ahire

[Dr Atul G- LNG]

Quick and clear @Yahav Mor