How to calculate End Date/Time based on Start Date/Time and Access Duration?

[Sirri]

• Hi All,
•  
• In one catalog item we have three variables
• Variable name               -   Type
  1)Start Date/Time            -Date/Time
  2)Access Duration          - Drop Down
  5 minutes
  15 minutes
  30 minutes
  1 hour
  5 hours
  12 hours
  1 Day
  5 Days
  10 Days
• 3)End Date/Time                  -Date/Time
• End Date should be auto fill by based start date/ time & access Duration.
  
  
• I have written the code but I'm not getting please let us know where I can modify.
• Note :suppose if start date is 10.50:00 19/10/2023
  If access Duration selected as 15 min
  Then End Date/Time is auto populate by
  11:05:00 19/10/2023
• Please let us know how can I achieve this. Please  provide source code also

[Alka_Chaudhary · Accepted solution]

Hello @Sirri ,

Please replace your scripts with the below script and try it.

Client Script:-

    var da = g_form.getValue('start_date_time');
    var ac = g_form.getValue('temporary_access_duration_required');
    var ga = new GlideAjax('EndDateAutoCalculate');
    ga.addParam('sysparm_name', 'test1');
    ga.addParam('sysparm_daa', da);
    ga.addParam('sysparm_acc', ac);
    ga.getXML(callback);

    function callback(response) {
        var answer = response.responseXML.documentElement.getAttribute("answer");
        alert(answer);

        g_form.setValue('end_date_time', answer);

    }

Script Include:

 test1: function() {
        var ab = this.getParameter('sysparm_daa');
        var ac = this.getParameter('sysparm_acc');
        var gdt = new GlideDateTime(ab);
        if (ac == '5 Minutes') {
            gdt.addSeconds(300);
        } else if (ac == '15 Minutes') {
            gdt.addSeconds(900);
        } else if (ac == '30 Minutes') {
            gdt.addSeconds(1800);
        } else if (ac == '1 Hour') {
            gdt.addSeconds(3600);
        } else if (ac == '5 Hours') {
            gdt.addSeconds(18000);
        } else if (ac == '12 Hours') {
            gdt.addSeconds(43200);
        } else if (ac == '1 Day') {
            gdt.addDays(1);
        } else if (ac == '5 Day') {
            gdt.addDays(5);
        } else if (ac == '10Days') {
            gdt.addDays(10);
        }
        return gdt;
    },

[Alka_Chaudhary]

@Sirri , Please share the updated scripts screenshot again.

[Sirri]

@Alka_Chaudhary 

Sure ,Please look on to this. Please let us know still any modifications required

[Alka_Chaudhary]

@Sirri , Script Include line 37, please replace the current.ac with ac.

[Sirri]

@Alka_Chaudhary 

I have modified but Still showing as null. let me know still any modification is required

[Alka_Chaudhary]

@Sirri , what this backend values of drop down variable access duration? Like-> what is the backend value of '5 minutes'?