Skip to main content
pshashipreetham
18-Opal
pshashipreetham18-Opal
18-Opal
October 8, 2021
Solved

Date in UTC

  • October 8, 2021
  • 2 replies
  • 2500 views

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

Best answer by pshashipreetham

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.

2 replies

P
PaiChung22-Sapphire I
22-Sapphire I
October 12, 2021

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

See Article here

    pshashipreetham
    18-Opal
    pshashipreetham18-OpalAuthor
    18-Opal
    October 12, 2021

    Hi @PaiChung ,

    Sorry that didn't help ... !

    Thanks,
    Shashi

    pshashipreetham
    18-Opal
    pshashipreetham18-OpalAuthorAnswer
    18-Opal
    November 27, 2021

    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.

    Terms & ConditionsAccessibility statement