Calculate time difference in minutes

Santhana Rajhan · ‎12-27-2017

I want a field to display the difference between two times in minutes.

Eg: Business Duration = 136

Prateek kumar · ‎12-27-2017

Hello Santhana

Please try below. g_form doesnot work server side

(function calculatedFieldValue(current) {

var dateString1 = new GlideDateTime(current.begin); //make sure variable name is begin

var dateString2 = new GlideDateTime(current.end); // make sure variable name is end

var diffSeconds = gs.dateDiff(dateString1, dateString2, true);

diffMins = diffSeconds/60;

return Math.round(diffMins); // return the calculated value

})(current);

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

View solution in original post

Prateek kumar · ‎12-27-2017

If your values are subjected to changes, you can create a On change client script and put the result value in your required feild using g_form.setValue()

Client scripts

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Santhana Rajhan · ‎12-27-2017

These don't frequently change. These fields will be used post incident from a reporting perspective.

Prateek kumar · ‎12-27-2017

Ok then you can configure a BR

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Vipin Murugesan · ‎12-27-2017

Hi Santhana,

Try below code, replace list line with your table name which you want to achieve.

var gr = new GlideRecord('Table Name');

gr.addQuery('active',true);

gr.query();

while(gr.next())

{

var holder = gs.dateDiff(gr.getDisplayValue('begin'), gr.getDisplayValue('end'),false) ;

holder = holder.split(' ')[1];

gs.print(holder);

}

benn23 · ‎12-27-2017

You can set the 'max_units' attribute in that field's dictionary record. Add this attribute: max_unit=minutes