question Setting the date/time field value to some specific time in EST time zone in Developer forum

Setting the date/time field value to some specific time in EST time zone

Community Alums — Mon, 09 Jan 2023 15:09:25 GMT

Hi All,

Currently our instance is in PST timezone. We have created a field on Incident form and I want to set the value as follows.

which means, I want to convert 8 AM EST to PST and need to place that time value in that field.

Can anyone suggest me on this. Thanks in advance.

Regards,

Ganesh

Re: Setting the date/time field value to some specific time in EST time zone

Basheer — Mon, 09 Jan 2023 15:16:35 GMT

Hi @Community Alums

Below is the script which can be useful for converting.

var dateTime = new GlideDateTime(); var targetTimezone = 'AST'; // provide the apt shortcut of timezone var tz = Packages.java.util.TimeZone.getTimeZone(targetTimezone); dateTime .setTZ(tz); var timeZoneOffSet = dateTime .getTZOffset(); dateTime .setNumericValue(dateTime .getNumericValue() + timeZoneOffSet);

Re: Setting the date/time field value to some specific time in EST time zone

laszloballa — Mon, 09 Jan 2023 15:40:30 GMT

Something like this might work too, depending your context (this is an example):

var est = Packages.java.util.TimeZone.getTimeZone('US/Eastern'); var pst = Packages.java.util.TimeZone.getTimeZone('US/Pacific'); var estGdt = new GlideDateTime(); estGdt.setTZ(est); var pstGdt = new GlideDateTime(); pstGdt.setTZ(pst); estGdt.setValue('2011-02-02 08:00:00'); gs.print('Original time: ' + estGdt); pstGdt.setValue(estGdt); pstGdt.addSeconds(10800); // add 3 hours gs.print('PST time: ' + pstGdt);