Check if date was yesterday

Type

Date

Option 1)

prop("Date").formatDate("L") 
    == 
    today().dateSubtract(1, "days").formatDate("L")

This will return a boolean value (true or false in a form of a checkbox)

Option 2)

if(
    prop("Date").formatDate("L") == today().dateSubtract(1 , "days").formatDate("L"),
    "Yesterday",
    "Not Yesterday"
)

This will return a text value

Note: This formula does not work with date ranges (dates that have both start and end dates).