TODAY
function TODAY(): number | string | boolean
Description
Returns the current date formatted as a date..
Returns
number | string | boolean
Try It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.TODAY());