How to set Duration field using back ground script?

prasannakumard · ‎11-27-2022

Hi Team,

I need to set below value in glide_duration type field. Please let me know how to set this value into Duration field:

Time = 100 (minutes)

How to set this 100 mins into Duration field.

I tried like below, but, the vaqlue is not set into duration field.

current.time_worked = new GlideDuration('100');

Please suggest and provide proper way/script to set minutes value into Duration field.

Thanks & Regards,

Prasanna Kumar

Bert_c1 · ‎11-28-2022

the following worked for me, I created a new field on my table with type 'glide_time'.

var xTable = new GlideRecord('x_snc_bctestappnew_app_table');
xTable.query();
while (xTable.next()) {
    gs.info("u_time = " + xTable.u_time + ".");
}
//new record
var numMinutes = 100;
var minutes = numMinutes%60;
var hours = (numMinutes - minutes)/60;
var timeVal = "1970-01-01 " + hours.toString() + ":" + minutes.toString() + ":00";
gs.info("timeVal = " + timeVal + ".");
xTable.initialize();
xTable.u_time = timeVal;
xTable.u_name = "New record";
xTable.insert();

you need extra logic if your value of minutes that you start with is greater than 1440 (one day).

View solution in original post

vkachineni · ‎11-27-2022

//Try this
var dur = new GlideDuration('0 01:40:00'); //100 mins = 1 hr + 40 mins
recGR.<duration_field> = dur;

prasannakumard · ‎11-27-2022

Thank you Vinod for your quick response. But, im trying to set time value dynamically. In one of my calculation, I got 100mins. How do we convert this 100 mins into 1hr 40 mins?

For example, if I get 40mins as answer, how to set this value dynamically into duration field. Please suggest the solution in that way.

Thanks & Regards,

Prasanna Kumar

vkachineni · ‎11-27-2022

Something like this??

var durStart = new GlideDateTime(gs.nowDateTime());
var durEnd = new GlideDateTime(gs.nowDateTime());
gs.print(durStart);
durEnd.addSeconds(1800); //From your calc minutes expressed as seconds 30 min * 60 sec = 1800 sec
gs.print(durEnd);

var duration = GlideDateTime.subtract(durStart, durEnd);
gs.print(duration.getDisplayValue());

//recGR.<duration field> = duration;

Bert_c1 · ‎11-27-2022

var numMinutes = 100;
var minutes = numMinutes%60;
var hours = (numMinutes - minutes)/60;
gs.info("numMinutes = " + numMinutes + " = " + hours + " hours and " + minutes + " minutes.");

gives:

*** Script: numMinutes = 100 = 1 hours and 40 minutes.