Convert GlideDateTime AM/PM to 24-hour format for calculating duration

[Jonathan77]

Hi, I am trying to get the Duration based on the difference between two GlideDateTimes. Getting the display value from the GlideDateTime does not seem to be pulling AM/PM or converting it to a 24-hour format for my calculation. My script is below. Is there something I am missing from this script to get the GlideDateTime in 24-hour format? 

Thanks in advance

(function executeRule(current, previous /*null when async*/) {

           

var actualstart = new GlideDateTime(current.u_diagnosis_time.getDisplayValue());

var actualfinish = new GlideDateTime(current.u_repair_time.getDisplayValue());

 

//If the begin and end times are present, calculate the duration

if (actualstart && actualfinish) {

 //  var difference = gs.dateDiff(actualstart, actualfinish, false);

            var difference = GlideDateTime.subtract(actualstart, actualfinish); 


   current.u_dttrt.setValue(difference); 
}

 

})(current, previous);

[Brad Bowman · Accepted solution]

Date/Time fields are stored in 24-hour format, it's the display preference that can make it am/pm, so I would just use:

var actualstart = new GlideDateTime(current.u_diagnosis_time);

var actualfinish = new GlideDateTime(current.u_repair_time);

[Jonathan77]

Thanks for the help Brad that solved my issue. The getDisplayValue() was unnecessary 

[michelek87]

This is not working for me.

var start = "2021-06-28 08:00:00 PM";
var startdate = new GlideDateTime(start);
gs.print(startdate);

I get this:

*** Script: 2021-06-28 08:00:00

[michelek87]

I figured it out... 

***

var start = "2021-06-28 08:00:00 PM";
var startdate = new GlideDateTime();
startdate.setDisplayValue(start, 'yyyy-mm-dd hh:mm:ss');
gs.print(startdate);