Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2010-03-29 : 11:04:55
|
| Why is this giving me an 'Unrecognized Error' below the DateInterval.Day=IIF(DateDiff(DateInterval.Day,Fields!Relevant_Date.Value,Today)=1),"LimeGreen","IndianRed") |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2010-03-29 : 11:22:55
|
| You have an extra bracket there:=IIF(DateDiff(DateInterval.Day,Fields!Relevant_Date.Value,Today)=1),"LimeGreen","IndianRed")Harsh Athalyehttp://www.letsgeek.net/ |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-03-29 : 11:32:34
|
Thanks Harsh, was not looking closely I guess  |
|
|
|
|
|
|
SSRS IIF Expression