Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Cab date should not be past start date in change request

Meghant Rai
Kilo Guru

Hi All,

 

I have a requirement where i have a field cab date which is a date field(OOB) and planned start date which is a date and time field (OOB)

I have to make sure that cab date should not  be greater than planned start date.

I have written script below but it's not working.

 

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
   if (isLoading || newValue === '') {
      return;
   }
   alert('Cab Date time',newValue);
  var plannedStartDate = g_form.getValue('start_date');
  var cabDate = g_form.getValue('cab_date');

  // Parse the dates
  plannedStartDate = new Date(plannedStartDate);
  cabDate = new Date(cabDate);

  // Check if cab date is after planned start date
  if (cabDate > plannedStartDate) {
    // Invalid date, show error message and revert cab date to planned start date
    alert('Cab date should not be after planned start date.');
    g_form.setValue('cab_date', '');
  }
  }
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Meghant Rai 

 

I am not a coder but can give you some path: Please chk OOTB validation.

AtulyaLNG_0-1699450121013.png

 

 

Also need to note, CAB dates also auto populated from CAB definition / CAB meeting as well and in that case may be your script not work. So please check all the scenarios. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************