NOW function

The Klipfolio NOW function returns the numerical date and time for the current date.

This function is typically used with the DATEVALUE function.

The syntax for the NOW function is:

NOW( )

NOW example

Let's look at a NOW function example.

DATEVALUE( NOW( ) , "dd-MM-yyyy HH:mm:ss" , GMT-4 )

Where the timezone is EST and today's date is 13/06/14.

-> ["13-06-2014 10:38:04"]

If the NOW function is not wrapped in the DATEVALUE function, the result is 1402670424.323.  This is the numerical or Unix time format for current date, 13 June 2014.

Related links: