Skip to main content

TODAY

Returns the current date in the <em>MM/dd/yy</em> format.

Syntax​

expression.TODAY();

expression - A variable that represents a ApiWorksheetFunction class.

Parameters​

This method doesn't have any parameters.

Returns​

number

Example​

This example shows how to return the current date in the MM/dd/yy format.

// How to get a current date.

// Use a function to get current date in MM/dd/yy format.

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.TODAY());