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.