NOW

Description

NOW returns the current date and time in ISO8601 format. If you want just the date, use TODAY.

Example

NOW()

This would return a text representing the current date and time in ISO8601 format, which means YYYY-MM-DDTHH:MM:SS.

NOW() can be used in other calculations, for example

SUBTRACT_YEARS(now(), 18)

would return the current time 18 years ago in the same format.