TODAY function

The Klipfolio TODAY function returns the Unix time value of the time the formula is calculated.

The syntax for the TODAY function is:


TODAY example

Let's look at a TODAY function example.

DATE_CONVERT( DATEVALUE( TODAY( "GMT" ) , "yyyy-MM-dd'T'HH:mm:ss.SSSZ" , ("GMT-4"), "yyyy-MM-dd'T'HH:mm:ss.SSSZ" , "MM-yyyy" )

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

Wrapping the formula in the DATE_CONVERT function lets you specify an appropriate display format.

-> ["06-2014"]

Note: The TODAY function updates when the formula is re-evaluated. A formula re-evaluates if there is a change in the underlying data. If the data source refreshes, and there is no change in the data, then the formula is not updated.

Related links: