Catalog Item client script - how to change date variable using onChange

[jasdwr1]

I am creating a Catalog Item with two dates.   The first date has a default value of "javascript:gs.nowDateTime" and the second date variable uses a GlideDateTime function to add 7 days to "today".   All this works fine.   If the first date is changed, I want to add 7 days to the new date and populate the second date variable.   Both date fields are defined as Date.

After searching the Community and trying various methods, I am still at a wall, the second date never changes.   The latest client script I've tried is

function onChange(control, oldValue, newValue, isLoading) {
// return if loading
if (isLoading){
    return;
}

// if start_date new value is blank, return
if (newValue == ''){
    return;
}

var updDate = newValue;
alert('initial date to change ' + updDate);
updDate.addDays(7);
alert('updated date ' + updDate);
g_form.setValue('end_date', updDate);
alert('new end date ' + g_form.getValue('end_date'));
return;

}

Prior to this I tried using the same script in the second date's default, tweaking for use in the client script.

function onChange(control, oldValue, newValue, isLoading) {
// return if loading
if (isLoading){
    return;
}

// if start_date new value is blank, return
if (newValue == ''){
    return;
}

// Get the datetime now
var nowGdt = new GlideDateTime(newValue);

// The name of the schedule
var myScheduleName = '24 x 7';

// The basis of our calculation
var dueDays = 7;
var dueWorkingHours = 24;

// The amount of time we want for the duration
var dueSeconds = dueDays*dueWorkingHours*60*60;
var leadTime = new GlideDuration(dueSeconds*1000);

// Calculate the Due Date!
var dueDateGdt;
var schedRec = new GlideRecord('cmn_schedule');

if (schedRec.get('name', myScheduleName)) {            
        var sched = new GlideSchedule(schedRec.sys_id);
        dueDateGdt = sched.add(nowGdt, leadTime, '');
}

g_form.setValue('end_date', dueDateGdt);
return;

This is the only client script for the catalog item.   Do I need to include something for the addDays or GlideDateTime?

thanks for viewing and helping!

[edwin_munoz]

Hello Doug,

Does the user needs to be able to see the end date while filling the form?

If not, maybe you can use a before insert/update business rule to fill the value of end date.

If the user must be able to see the end date then you can use pure javascript to accomplish this

function onChange(control, oldValue, newValue, isLoading) {

   // return if loading

   if (isLoading){

       return;

   }

   // if start_date new value is blank, return

   if (newValue == ''){

       return;

   }



   var initialDate = newValue.replace(/-/g, "/");

   initialDate = new Date(initialDate);

   var days = 7;

   var millisecondToAdd = days * 24 * 60 * 60 * 1000;



   var endDate = new Date (initialDate   + millisecondToAdd );

   endDate = endDate.replace(/\//g, "-");



   g_form.setValue('end_date', endDate);

   return;

}

Good luck.

[jasdwr1]

Thanks Edwin.

I tried your code and no luck.   Throwing some alerts in, the initialDate = new Date shows initialDate as Mon Mar 23 2015 00:00:00 and when I get to the endDate = new Date shows endDate as Invalid Date.

[edwin_munoz]

Sorry Doug,

Just change this line

var endDate = new Date (initialDate   + millisecondToAdd );  

to this one

var endDate = new Date (initialDate.getDate()   + millisecondToAdd );  

I think that you can also get rid of the "replace" statements becuase of the way that the date is stored.

Thanks!

[manikorada · Accepted solution]

Doug,

A simple script to do that is :

var dateMS = getDateFromFormat(newValue,g_user_date_format);

          dateMS += 7 * 24 * 60 * 60 * 1000;

          var newDT = new Date();

          newDT.setTime(dateMS);

          g_form.setValue('end_date',formatDate(newDT,g_user_date_format));