Show data through yesterday

[jenmclean]

I have one sheet in my app that I want to show data through yesterday only. I am displaying data for this week but DO NOT want to include today's data.

My formula is as follows:

({1<CurrentPeriodWeek={1}, INV|VoidFlag-={Y}, DB|Source={'TP'}, LOC|CorpFlag={0}, TP|StoreNumber-={1,9}, INV|TransTypeID={1,17}>}TS|GrossRev)

Suggestions?

Thanks

[MK_QSL · Accepted solution]

Add Datefield also.

Date = {'<$(=Today())'}

[jenmclean]

Thanks! That did it.

Jennie