NOW function

NOW() NOW()

Returns — Number

A sequential serial number representing the current date and time.

Returns the current date and time.

The value returned from this function can be set as the initial value displayed by a date and time field.

Examples

NOW()NOW()

Returns the current date and time.

FORMATDATE(NOW()) & ", " & FORMATTIME(NOW())FORMATDATE(NOW()) & ", " & FORMATTIME(NOW())

Returns today's date, followed by a comma, a space and the current time.