Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you mean on a visualization?
you can use setanalysis
Sum( {<YourDate={"<=$(today()-1)"}>} LineSalesAmount)