Actual start and end date in change request should be in between change request planned start date a

[Tulasiram1]

Actual start and end date in change request should be inbetween change request planned start date and planned end date

[shyamkumar VK]

Hello @Tulasiram1  ,

you need to Write on Submit Client Script for this , use below code 

function onSubmit() {
  // Get the planned start date and end date
  var plannedStart = g_form.getValue('planned_start_date'); // update with your field
  var plannedEnd = g_form.getValue('planned_end_date');//update with your field

  // Get the actual start date and end date
  var actualStart = g_form.getValue('start_date'); //update with your field
  var actualEnd = g_form.getValue('end_date'); //update with your field

  // Check if the actual start date is before the planned start date
  if (actualStart < plannedStart) {
    g_form.showFieldMsg('start_date', 'Actual start date cannot be before the planned start date', 'error');
    return false;
  }

  // Check if the actual end date is after the planned end date
  if (actualEnd > plannedEnd) {
    g_form.showFieldMsg('end_date', 'Actual end date cannot be after the planned end date', 'error');
    return false;
  }

  return true;
}

[Tulasiram1]

I have written ths script then I am trying to test. I am getting error while filling planned start date.

[shyamkumar VK]

Hello @Tulasiram1  ,

Did you updated your backend field values correctly in the Script , also can you please share the Code screenshot which you have written in CS

[Tulasiram1 · Accepted solution]

Write Before BR update.