NOW
function NOW(): number | string | boolean
Description
Returns the current date and time formatted as a date and time..
Returns
number | string | boolean
Try It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.NOW();
oWorksheet.GetRange("C1").SetValue(ans);