How to autopopulate 'Due Date' field value depending on 'employee start date'

[bhuvana7]

Hello Everyone,

1) I need to Auto populate the 'Due Date' field value depending on employee's start date.

2) Due Date field I created it in 'HR Task' table and 'employee start date' field value is available in 'HR Profile' table.

3) So I created a Before-Insert, Update business rule in the 'HR Task Table' to get the value of 'employee start date' and to populate 'Due Date' value.

But whatever I created that is not working as expected, I am attaching the screenshots for reference. Please help me out with your suggestions/solutions.

Many Thanks in Advance!!

Kind Regards,

Bhuvana

[Claude DAmico]

Try this.

var date;
var par = current.parent.subject_person;
var gr = new GlideRecord('sn_hr_core_profile');
gr.addQuery('user', par);
gr.query();
while(gr.next()){
     date = new GlideDateTime(gr.getValue('employment_start_date'); //If this is a DATE ONLY field, change to date = new GlideDateTime(gr.getValue('employment_start_date') + " 00:00:00");
     date.addDays(7);
}
current.u_due_date = date; //If you need DATE ONLY, change to current.u_due_date = date.getDate();
current.update();

[bhuvana7]

Hello Claude,

I am getting these errors, can you please clarify this?

Error Message

1)java.sql.BatchUpdateException: (conn=3240220) Duplicate entry '7bce2abbdbe729d06697c59b13961940' for key 'PRIMARY'

Error Message

2)Invalid insert

[Claude DAmico · Accepted solution]

Remove the current.update() line. I forgot you mentioned this is a BEFORE business rule.

[bhuvana7]

Thank you Claude, working as expected.