How to convert GMT date to EST

jesusemelendezm · ‎09-26-2014

When importing expirydate from LDAP to sys_user table - I am obtaining an incorrect date. If user expiry date in Active directory is 31/12/2014 the date being displayed on the user form on ServiceNow is 01/01/2015 I was told that It is being imported on GMT and I need to convert it to EST. Can I do it directly on the date field?

Jim Coyne · ‎09-28-2014

It will only affect that one particular variable and field. Your script is not quite right though as you need to modify the timezone for your gDate variable. You need to put:

//converting GMT to Canada/Eastern


var tz = Packages.java.util.TimeZone.getTimeZone("Canada/Eastern");


gDate.setTZ(tz);

...right after you initialize the variable and before you assign the date to it. You should end up with:

var gDate = Packages.com.glide.glideobject.GlideDateTime();


//converting GMT to Canada/Eastern


var tz = Packages.java.util.TimeZone.getTimeZone("Canada/Eastern");


gDate.setTZ(tz);


gDate.setValue(msDate);

View solution in original post

Chandan23 · ‎09-28-2014

target.date= gdt.getDisplayValue();
make use of thei

Make use of this line of code.

jesusemelendezm · ‎09-29-2014

Chandan,

Do you mean instead of target.u_expiry_date=";

?

Chandan23 · ‎09-29-2014

Yes, target.u_expire_date = gdt.getDisplayValue();

Iyyappan · ‎08-10-2016

It Works!!

Just add date_field.getDisplayValue() which gives you actual date/time.

Jim Coyne · ‎11-06-2014

Did you ever solve this?