Skip to main content
pshashipreetham
pshashipreetham19-Tanzanite
19-Tanzanite
October 8, 2021
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

pshashipreetham
pshashipreethamAnswer
19-Tanzanite
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.

Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
View in thread

3 replies

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

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

See Article here

Translate
    pshashipreetham
    pshashipreetham19-TanzaniteAuthor
    19-Tanzanite
    October 12, 2021

    Hi @PaiChung ,

    Sorry that didn't help ... !

    Thanks,
    Shashi

    Translate
    Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
    pshashipreetham
    pshashipreetham19-TanzaniteAuthorAnswer
    19-Tanzanite
    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.

    Translate
    Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
    Terms & ConditionsAccessibility statement