glide date time difference

[Deepika54]

hello experts,

i have a glide date time value which is in "2022-11-17 02:45:00" format. I need to subtract 5 hours 30 mins from it. Can anyone tell me how to do it. I am new to Scripting.

Thanks in advance.

[Anand Shukla]

Hi Deepika

Below script will be helful for you.

var dateField = new GlideDateTime('2021-05-04');

var nowTime = new GlideDateTime();

var dur = new GlideDuration();

dur = GlideDateTime.subtract(dateField, nowTime);

var days = dur.getDayPart();

gs.info(days);

Mark it correct or helpful.

Thanks

[Deepika54]

i need to subtract only the time part. not the date

[newhand]

@Deepika54 

Try below code.

var gdt = new GlideDateTime("2011-08-31 08:00:00");
var gtime1 = new GlideTime();
gtime1.setValue("05:30:00");
gdt.subtract(gtime1);
gs.info(gdt );

[Sagar Pagar · Accepted solution]

Hi @Deepika54,

Try this scripts -

var dateTime = new GlideDateTime('2022-11-17 02:45:00');

var dateTimeObj = new GlideDateTime(dateTime);
dateTimeObj.addSeconds(-19800); // 5.5 hrs = 19800 seconds

gs.info("Given date-time: " + dateTime + " - after date-time: " + dateTimeObj);

Thanks,
Saagr Pagar