I am trying to create a few SSRS Expressions that will highlight rows when the following cases are met: When the date field = today...When the date field >= today through +120 days...When the date field = Yesterday and all days before that...

This is coming from a Crystal Report with the following code:

if  {usp_ND044R01;1.review_Date} in  AllDatesToYesterday
then crYellow
else
if  {usp_ND044R01;1.review_Date} in  CurrentDate to CurrentDate+ 120
then crYellow
else
crWhite

This is where I am at:

=IIF(Fields!review_Date.Value = Today(), "Yellow", "No Color")
=IIF(Fields!review_Date.Value <= dateadd("d",120,today()), "Yellow", "No Color")
=IIF(Fields!review_Date.Value <= dateadd("d",-1,today()), "Yellow", "No Color")

I always get an error (red squiggly line under the parenthesis right after today. E.G. today**()**

Any suggestion would be helpful.

Thanks