IIF and CDate getting #error in SSRS expression?
<p>I've got data from a db in Reporting Services, which contains the datetime as a integer like this: 20160511, but in some case it is just a 0. I need an expression to do the following: if the value is 0, put the string "never", else put the data in correct format. 
I've tried to use an expression in SSRS report, something like this:</p>

<pre><code>==IIF(Fields!name.Value=0,"never", Cdate(...))
</code></pre>

<p>If the data is correct, working fine, and shows the date, but in the fields, where 0, i'm getting this error: #error and some warnings. </p>

<p>If i just use this:</p>

<pre><code>==IIF(Fields!name.Value=0,"never", "something else")
</code></pre>

<p>Here is working the true branch, it shows the never and the something else string correctly. I've tried the first code wth Is nothing date, and others, but it didn't worked. </p>

<p>I'm really confusing. Has anybody any idea for fix the first code?</p>