NOW function

  • Article

NOW function

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

See also

Returns the current date and time value.

Syntax

NOW ( )

Remarks

NOW is automatically recalculated every minute.

Example 1

NOW( )

Returns the current date and time, such as 9/27/1999 12:03:30 PM.

Example 2

FORMAT(NOW(),"dd MMM., yyyy hh:mm")

Returns the current date and time formatted as 27 Sep., 1999 12:03.

Example 3

NOW()+2EW.

Returns the current date and time plus two elapsed weeks, such as 10/11/99 12:03:30 PM.