How do I get/create an expression to only show dates < yesterday

[jaymeknapp]

I'm creating a table that a column of dates, but I only want to see those lines where the date is < yesterday.

Here is field that is giving me the date:

=DATE([Transaction Line Expected Ship Date], 'MM/DD/YY')

Jayme

[dplr-rn]

Do you mean on a visualization?

you can use setanalysis

Sum( {<YourDate={"<=$(today()-1)"}>} LineSalesAmount)