Skip to main content
Oct 8, 2021 5:18 PM UTC
Solved

Date in UTC

Hi,

When result =  new Date() is executed, the result Time format is in IST, but as per the customer point of view it should be in UTC, how can it be done ?

Note: the output of the service should be DATETIME


@paic @slangley @c_lowy 

Thanks,
Shashi

Nov 27, 2021 9:38 AM UTC

Hi,

Since no solution is avaliable for this, using third party API's for Time is the easiest way.
In the Below Code used the CDT timezone, similarly it can be changed to the UTC.

var params = {
 proxyScheme: 'http' /* STRING */,
 headers: {"Accept-Encoding":"gzip, deflate, br","Accept":"*/*","Content-Type": "application/json"},
 ignoreSSLErrors: true,
	url: "http://worldtimeapi.org/api/timezone/America/Chicago" /* STRING */,
};

// result: JSON
var CDTdate = Resources["ContentLoaderFunctions"].GetJSON(params);
//date = CDTdate.datetime;
date = ((CDTdate.datetime).split("T")[0]);
time = ((CDTdate.datetime).split("T")[1]);
timestamp = ((time).split(".")[0]);
hours = timestamp.split(":")[0];
if(hours > 12 ){
 result = date + " " + timestamp + " PM CDT";
}
else{
 result = date + " " + timestamp + " AM CDT";
 }


Thanks,
Shashi.

3 replies

Oct 12, 2021 6:08 PM UTC

Google search shows there should be a Date.UTC available in javascript

See Article here

Oct 12, 2021 6:18 PM UTC

Hi @PaiChung ,

Sorry that didn't help ... !

Thanks,
Shashi

pshashipreethamAuthorAnswer
Nov 27, 2021 9:38 AM UTC

Hi,

Since no solution is avaliable for this, using third party API's for Time is the easiest way.
In the Below Code used the CDT timezone, similarly it can be changed to the UTC.

var params = {
 proxyScheme: 'http' /* STRING */,
 headers: {"Accept-Encoding":"gzip, deflate, br","Accept":"*/*","Content-Type": "application/json"},
 ignoreSSLErrors: true,
	url: "http://worldtimeapi.org/api/timezone/America/Chicago" /* STRING */,
};

// result: JSON
var CDTdate = Resources["ContentLoaderFunctions"].GetJSON(params);
//date = CDTdate.datetime;
date = ((CDTdate.datetime).split("T")[0]);
time = ((CDTdate.datetime).split("T")[1]);
timestamp = ((time).split(".")[0]);
hours = timestamp.split(":")[0];
if(hours > 12 ){
 result = date + " " + timestamp + " PM CDT";
}
else{
 result = date + " " + timestamp + " AM CDT";
 }


Thanks,
Shashi.