TIMENOW()

Current time

Returns the current time (Time value).

Sample usage

TIMENOW() is equivalent to TIME(NOW()). See also: NOW(), TIME()

(TIMENOW() - 1) returns the time one hour in the past.

(TIMENOW() + 1) returns the time one hour in the future.

(TIMENOW() + 24) returns the time one day in the future.

Syntax

TIMENOW()

Notes

The values returned by NOW(), TODAY(),  and TIMENOW() reflect the timezone offset of the user's device. For example, if the timezone of the user's device is Pacific Standard Time (PST), the value returned is UTC-08:00; if the timezone of the user's device is Hong Kong, the value returned is UTC+8:00.

When the user's device contacts the server to read or update data, the device includes its timezone with the request. The server uses the timezone of the user's device when performing time and date calculations. For example, when the server evaluates security filters and workflow rules that include dates and times.

To understand how your mobile device's locale or browser's language setting can impact the format of the returned value, see Considerations for apps using Date, Time, and DateTime formats.

See also

Date and time expressions

DATETIME()

HOUR()

MINUTE()

NOW()

SECOND()

TIME()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
6638219503552777604
true
Search Help Center
true
true
true
false
false