I'm getting an Overload resolution failed. No accessible IIf accepts this number of arguments
=IIF((InStr(Fields!GRP_NAME.Value,"SOCS") > 0 OR InStr(Fields!GRP_NAME.Value, "TOC") > 0) , (IIF(DateAdd("YYYY",3,Fields!CP_PRD_END_DT.Value) < Fields!CP_PRD_END_DT.Value , "*See CO" IIF(Fields!SAMPLE_MONTH.Value>0 ,"YES" IIF(Fields!CP_PRD_BEGIN_DT.Value < Globals!ExecutionTime ,"NO","FUTURE")))) I have tried tweaking this several times and can't get it to work. Any help would be much appreciated!
@Kristin The syntax visually appears to have errors but it is not possible to figure out how to fix them without explanation. Visually, it is easy to see that there is no way to have "\*See Co" directly followed by the next IIF, there has to be something between them. Same applies to the line reading '"YES" and the next line beginning with IIF. Every long if needs to have 3 parts, i.e. condition, true part, false part). In your case, it appears that the outermost IIF is missing the false part. It would be easier if you could just explain what you would like to return from this expression (which conditions cause what), so it will be possible to get the syntax corrected.
Below is what I have working now, but every line with SOCS or TOCS is returning with a *See CO", where I need them to return "*FUTURE" if the DateAdd evaluates to false. Everything else but this is working. Ugh. =IIF(InStr(Fields!GRP_NAME.Value,"SOCS") > 0 OR InStr(Fields!GRP_NAME.Value, "TOCS") > 0 AND DateAdd("YYYY",3,Fields!CP_PRD_END_DT.Value) < Fields!CP_PRD_END_DT.Value, "*See CO", IIF( Fields!SAMPLE_MONTH.Value>0,"YES", IIF( Fields!CP_PRD_BEGIN_DT.Value < Globals!ExecutionTime ,"NO","*FUTURE" ) ) )
@Kristin The way it is written only if line with SOCS is true then it returns \*See Co regardless of what the TOCS and dateadd evaluate to. It will also return \*See Co if both TOCS and dateadd are true. This happens because if you don't have parentheses around the OR conditions then the dateadd gets evaluated bunched up with TOCS. To change, please add parentheses around InStr OR Instr. This will cause this: if any of the 2 InStr are true and also dateadd is true, only then the \*See Co will be returned. Otherwise, should none of the InStr be true or (if one or both are true) but the dateadd is false then it will proceed further. It will then return YES if the sample month is > 0. If not then it will check begin DT and return either NO or , finally FUTURE depending on that last check. Here is your expression with parentheses added:
IIF(
(InStr(Fields!GRP_NAME.Value,"SOCS") > 0 OR InStr(Fields!GRP_NAME.Value, "TOCS") > 0)
AND DateAdd("YYYY",3,Fields!CP_PRD_END_DT.Value) < Fields!CP_PRD_END_DT.Value,
"*See CO",
IIF( Fields!SAMPLE_MONTH.Value > 0,
"YES", IIF( Fields!CP_PRD_BEGIN_DT.Value < Globals!ExecutionTime ,"NO", "*FUTURE" )
)
)
