how to set yesterday

[sersal10]

Hi all. I am trying to find how to set yesterday in a set analysis and it doesn´t work for me as I see from old posts:

Date(Today()-1,'MM/DD/YYYY') or without the format.

Also I need that to calculate the sum of the quantity that was sold yesterday. I tried this but it seems it gives me the accumulated sales till today:

Sum(${<date(sold_date)={'==Date(Today() -1)'}>}quantity)

Any help appreciated!!

[BrunPierre · Accepted solution]

Format in script

Date(sold_date,'DD/MM/YYYY') as sold_date

Then, use this expression

Sum({$<sold_date={"$(=Date(Today()-1,'DD/MM/YYYY'))"}>} quantity)