Format Cell based on conditions in SSRS VS2010

  • Hello,

    Struggling to write a Iif or Switch statement in the expression for the following:

    If the cell value is "Y" then nothing

    If TODAY() is 10 day or less prior to SV3 date (Field SV3Date) then Red color.

    Thank you.

  • Struggling to write a Iif or Switch statement in the expression for the following:

    If the cell value is "Y" then nothing

    If TODAY() is 10 day or less prior to SV3 date (Field SV3Date) then Red color.

    IIF(Column="y",Nothing,IIF(DATEDIFF("d",TODAY(),[SV3Date])<10,"Red","Black"))

    ??

  • Thank you very much. I was able to take this hint and fix my problem. This can be closed now. Thanks again ..!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply