show calendar date/time fields in EST

Shivam Saxena1 · ‎12-24-2020

Hello,

We have 2 fields in a form.

1. Expected Start Date/Time

2. Expected End Date/Time

The above 2 fields show the system date/time.

I want 2 more fields below below the above mentioned fields with name :

1. Expected Start Date/Time (EST)

2. Expected End Date/Time (EST)

Requirement :

Expected Start Date/Time (EST) will be copied from Expected Start Date/Time once the user fill this field and show EST time.

Expected End Date/Time (EST) will be copied from Expected End Date/Time once the user fill this field and show EST time.

Can someone please help in how to achieve this functionality?

NOTE : The fields are in scoped application.

asifnoor · ‎01-03-2021

Okay.

Hi create a SI in global scope and then call that Si from your client script. Then you can use the following code to convert your date/time to EST format.

Script Include

getConvertedDate: function() {
       var mydate = new GlideDateTime(this.getParameter('sysparm_date').toString());
       var gdt1 = new GlideDateTime();
       //sets to EST
       var tz = Packages.java.util.TimeZone.getTimeZone("EST");
       gdt1.setTZ(tz);
       gdt1.setValue(mydate); 
       return gdt1.getDisplayValue(); //returns the date/time in EST timezone as a string.
},

Mark the comment as a correct answer and also helpful if this helps to solve the problem.

View solution in original post

asifnoor · ‎01-04-2021

Glad it worked. Kindly mark the other comments as helpful if they had helped to solve the problem.