Team:

Using this IIF statement:

Nothing))

Released_DT = a date  - 09/03/2015 or 09/02/2015

Date2 = returns another date value in this case 09/03/2015

What I'm trying to do is: count distinct number of people (Fields!Name.Value) if the Relased_DT = Date2.

My IIF statement is returning a zero value.

Thanks,

jer

Hi ,

Are the date format same in both the fields or of different types.Because that might be a reason why it will fail

Milan:

Using the following:

Released_DT = RelasedDT (smalldatetime, null) / covert(varchar, tblrelease.releaseddt, 101) as [Released DT]

Date2 = convert (varchar(8), {fn Now()}, 22) as [Date2]

Thanks,

jer

Team:

Got it to work with the following:

=

"Total Released for date  " & Fields!Date2.Value & ":  " & CountDistinct(IIF(Fields!Released_DT.Value = Today(), Fields!Name.Value, Nothing))

and

"Total Released for date    " & Fields!Date1.Value & ":  " & CountDistinct(IIF(Fields!Released_DT.Value = DateAdd("d",-1,Today()), Fields!Name.Value, Nothing))

Thanks

Hi jr7138,

Glad to hear that your issue had been solved by yourself. Thank you for your sharing which will help other forum members who have the similar issue.

Would you please mark the solution as an answer? So that we are able to close the thread.
 
If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu