Add days to Date/Time field and show on Service Portal

[Shrey hurana]

Hello All,

I have a requirement where I have 2 fields i.e. 'Please Select the duration' (Radio Button with 2 fields i.e. 24 Hours and 48 Hours)(Name - please_select_the_duration) and 'Start Date' (Date Time field) (Name - start_date). Based upon the radio button selected and on change of Start Date the End date field needs to be populated by adding 24 Hours or 48 Hours based upon the selectiom.

I tried multiple approaches from community, but no luck. Can someone please help me with the same. 

Script Include:

pastDate: function() {

         var selected_date = new GlideDate();

         selected_date.setDisplayValue(this.getParameter('sysparm_Date'));

         var current = new GlideDate();

         var start_check = gs.dateDiff(current, selected_date, true);

        var radio_button = this.getParameter('sysparm_Duration');

        var start_date = this.getParameter('sysparm_Date');

        if (start_check > 0 || selected_date >= current)

            //return 0;

            {

                return 'SHREY';

            }

        else if (start_check < 0)

            return 2;

    },

Client Script (Written on change of Start Date field):

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

    if (isLoading || newValue == '') {

        return;

    }

    var radio_button = g_form.getValue('please_select_the_duration');

var ga = new GlideAjax('UtilsAjax');

        ga.addParam('sysparm_name', 'pastDate');

        ga.addParam('sysparm_Date', newValue);

        ga.addParam('sysparm_Duration',radio_button);

        ga.getXML(CheckDateValidation);

    }

function CheckDateValidation(response) {

    var answer = response.responseXML.documentElement.getAttribute("answer"); 

    if (answer == 2) 

        {

            g_form.setValue('start_date', '');

        g_form.showFieldMsg('start_date', 'Please select the future date','error');

        }

        else 

{

    alert('IMPLEMENTATION IN PROGRESS');

}

}

[Vishal Birajdar]

Can you check what you are getting 'result.endDate' in script include by putting some logs.

[Shrey hurana]

Yes I have checked in logs it is showing empty value. Also I tried to print the value in Client Script through alert and it is showing as - [object Object]

Because of this reason I guess it is not showing anything on the end date field too

[Vishal Birajdar]

Hi @Shrey hurana 

Have done some changes & checked Its working for me...!!

Can you try  

Script Include:

pastDate: function() {

      // object to return  data  
    var result ={
          'isStartDateValid':'',
          'endDate':''
               }

// get values selected on form
        var radio_button = this.getParameter('sysparm_Duration');
        var start_date = this.getParameter('sysparm_Date');

//Check if start date is not past date
var getCurrentDate = gs.nowDateTime();

if(start_date > getCurrentDate) {

result.isStartDateValid = true;

} else {

result.isStartDateValid = false;

}

// get future date depends upon duration selected.

var dt = new GlideDateTime(start_date);

if (radio_button == '24 hours'){ //use your backend value here
dt.addDaysUTC(1);   //24 hrs = 1 day

} else {

dt.addDaysUTC(2); //48 hr = 2 days

}

result.endDate = dt.getDisplayValue();

return JSON.stringify(result);

Client Script (Written on change of Start Date field):

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

    if (isLoading || newValue == '') {
        return;
    }

    var radio_button = g_form.getValue('please_select_the_duration');
    var ga = new GlideAjax('UtilsAjax');
    ga.addParam('sysparm_name', 'pastDate');
    ga.addParam('sysparm_Date', newValue);
    ga.addParam('sysparm_Duration',radio_button);
    
     ga.getXMLAnswer(CheckDateValidation);

    }

function CheckDateValidation(answer) {

          var result= JSON.parse(answer);

          if (result.isStartDateValid == true) {

        //Set the end date depending upon result returned by script include 
         g_form.setValue('end_date',result.endDate);
          } else {

           alert("start date should not be past date");
          }

       }

}

Output :

Time displayed may be different because of timezone

[Shrey hurana]

Hello I tried the same code but it is not working as I am using the a different Date Time format w.r.t yours format. I am using the format as MMM DD,YYYY HH:MM:SS (Example  - Oct 06, 2023 09:06:36)

[Vishal Birajdar]

You can format the end date w.r.t yours in script include and then return it.