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:
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.