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

Shivam Saxena1 · ‎01-04-2021

Hi Asif,

1 more small thing. When I am sending email notification, and printing EST time, it is printing the correct time in EST but printing GMT.

Time is correct but in place of GMT it should show EST.

Can you please help?

Thanks.

asifnoor · ‎01-04-2021

Hi,

Try using a mail script and display saying

template.print(current.getDisplayValue("your_date_field"));

Mark the comment as correct/helpful if it helps.

Shivam Saxena1 · ‎01-04-2021

Hi Asif,

Tried your answer but no luck. Now it is coming blank.

I need to show EST in place of GMT in email notification as the time printed here is in EST.

Email Script :

Notification Email :

Thanks.

asifnoor · ‎01-04-2021

Sorry. it should be

current.your_field_name.getDisplayValue()

Shivam Saxena1 · ‎01-04-2021

Hi Asif,

It is not printing the date.

However, it is printing 'Here'.

Notification :

Thanks.