Skip to main content

SetTimeUTC

Sets the timestamp of the comment reply creation in UTC format.

Syntax

expression.SetTimeUTC(nTimeStamp);

expression - A variable that represents a ApiCommentReply class.

Parameters

NameRequired/OptionalData typeDefaultDescription
nTimeStampRequiredNumber | StringThe timestamp of the comment reply creation in UTC format.

Returns

This method doesn't return any data.

Example

Set the timestamp of the comment reply creation in UTC format.

// How to change a timestamp in UTC when a reply was created in a spreadsheet.

// Add a reply then update its creation time in UTC format and show it in the worksheet.

let worksheet = Api.GetActiveSheet();
worksheet.GetRange("A1").SetValue("1");
let range = worksheet.GetRange("A1");
let comment = range.AddComment("This is just a number.");
comment.AddReply("Reply 1", "John Smith", "uid-1");
let reply = comment.GetReply();
reply.SetTimeUTC(Date.now());
worksheet.GetRange("A3").SetValue("Comment's reply timestamp UTC: ");
worksheet.GetRange("B3").SetValue(reply.GetTimeUTC());