<div>
your expression evaluate only the no of days difference between now() and Fields!Max_Date.Value . because you have mentioined the interval as &quot;d&quot;<br />
<br />
<br />
<br />
Tell me what is your exact requirement?
</div>


your expression evaluate only the no of days difference between now() and Fields!Max_Date.Value . because you have mentioined the interval as "d"



Tell me what is your exact requirement?

<div>
its the same requirement, but evaluate the day and month.<br />
as an example.<br />
22-05-2012 wiil be the same as 22-04-2012, which is incorrect.
</div>


its the same requirement, but evaluate the day and month.
as an example.
22-05-2012 wiil be the same as 22-04-2012, which is incorrect.

<div>
Now I noticed, the error is in your expression: &gt;30 is also &gt;7 and you've put the &gt;7 condition first.<br />
<br />
Try this instead:<br />
<br />
=Switch(<br />
&nbsp; DateDiff(&quot;d&quot;, Fields!Max_Date.Value, Now()) &gt;&nbsp;30, &quot;Red&quot;,<br />
&nbsp; DateDiff(&quot;d&quot;, Fields!Max_Date.Value, Now()) &gt;&nbsp;7, &nbsp;&quot;Orange&quot;, <br />
&nbsp; DateDiff(&quot;d&quot;, Fields!Max_Date.Value, Now()) = 0, &quot;Green&quot;, <br />
&nbsp; true, &quot;Black&quot;)
</div>


Now I noticed, the error is in your expression: >30 is also >7 and you've put the >7 condition first.

Try this instead:

=Switch(
  DateDiff("d", Fields!Max_Date.Value, Now()) > 30, "Red",
  DateDiff("d", Fields!Max_Date.Value, Now()) > 7,  "Orange",
  DateDiff("d", Fields!Max_Date.Value, Now()) = 0, "Green",
  true, "Black")

<div>
<div class="content wysiwyg-content">
i have the following expression.<br />
<br />
=IIf(DateDiff(&quot;d&quot;, Fields!Max_Date.Value, Now()) = 0, &quot;Green&quot;, <br />
Iif(DateDiff(&quot;d&quot;, Fields!Max_Date.Value, Now()) &gt;&nbsp;7, &nbsp;&quot;Orange&quot;, <br />
Iif(DateDiff(&quot;d&quot;, Fields!Max_Date.Value, Now()) &gt;&nbsp;30, &quot;Red&quot;, &quot;Black&quot;) ) )<br />
<br />
but its only evaluating the day and not the month.<br />
my date is 22-05-2012.<br />
<br />
thanks
</div>
</div>


i have the following expression.

=IIf(DateDiff("d", Fields!Max_Date.Value, Now()) = 0, "Green", 
Iif(DateDiff("d", Fields!Max_Date.Value, Now()) > 7,  "Orange", 
Iif(DateDiff("d", Fields!Max_Date.Value, Now()) > 30, "Red", "Black") ) )

but its only evaluating the day and not the month.
my date is 22-05-2012.

thanks

ssrs date expression

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.