compare date to yesterday

[#1]

I have a date columm that I need to filter for the date of yesterday. I am not sure how to create such expresssion.

thanks in advance,

Haidar.

[MayilVahanan]

HI

Try like this

=Sum({<Date = {'$(=Date(Max(Date)-1))'}>}Sales)

hope it helps

[rustyfishbones]

Or

=SUM ({<Date = {'$(=Date (Today ()-1))'}>} Sales)