YESTERDAY function

The Klipfolio YESTERDAY function returns the numeric date for yesterday.

The syntax for the YESTERDAY function is:

YESTERDAY( )

YESTERDAY examples

Let's look at some YESTERDAY function examples.

DATERANGE( DATEVALUE( DATE_ADD( YESTERDAY ( ), day , -60 ) , "dd/MM/yyyy") , DATEVALUE( YESTERDAY( ) , "dd/MM/yyyy" ) , "dd/MM/yyyy" )

Returns data for the last two months starting from yesterday's date.

The following example is from an Excel data source.

 

A

B

1 06/15/2014 10
2 06/16/2014 12
3 06/17/2014 14

SELECT( B:B , (DATE( A:A , "MM/dd/yyyy , "EST" ) = YESTERDAY( "EST" ) ) ) 

Returns values for yesterday's date where yesterday's date is 06/16/2014 . 

-> ["12"]

Related links: