Set analysis with Todays date and yesturdays date

[helen_pip]

Hello

I have some set analysis which works to gain a count for today's date

However, I also want to pick up yesturday's date

Can someone kindly show me how to amend my code to include Today and yesturday's data

=SUM( {1<Test={"$(=Date(Today(), 'DD/MM/YYYY'))"}>}QuarterlyBreaches_Breaches)

Kind Regards

Helen

[#2 · Accepted solution]

You can simply use a variable:

vYesterday = today()-1

Regards

f.