show calendar date/time fields in EST

[Shivam Saxena1]

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.

[Shivam Saxena1]

Hi Asif,

I already tried this. It is not working as my mail_script and notification is in scoped application.

It is not printing anything.

mal_script : in scoped application.

Can we make mail_script in global and call from notification which is in scoped application if that way it works?

Thanks.

[asifnoor]

In that case, lets call the same SI which we have used earlier. You can modify that SI function slightly like this so that it can be used from server side as well as client side.

getConvertedDate: function(mydate) {
       var mydate = JSUtil.nil(mydate) ? new GlideDateTime(this.getParameter('sysparm_date').toString()) : mydate;
       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.
},

Then in your mail script, simply call

template.print(new global.your_si_name().getConvertedDate(current.your_field_name));

[Shivam Saxena1]

Hi Asif,

I have again tried writing the script include code directly in mail_script and it worked.

But the issue here is, it is showing EST but time is converted in GMT only. It has converted 'Expected Start Date/Time' in GMT and printing the same.

[asifnoor]

Hi,

Try the code that I gave above. and pass your Expected start/end date field (not est) to the SI and it will give you back the EST field

[Shivam Saxena1]

Hi Asif,

It is working now. Thanks for your help. Really appreciate.

Thanks.