iff returning #error

• LoosinMaMind

  Hall of Fame

  Points: 3366

  More actions

  June 21, 2013 at 4:46 am

  #395012

  Hi

  I have the following set as the Expression value in a report field.

  =

  IIf(Fields!DOWL.Value <> "" and Fields!Adm_Non_Admit_Flag.Value = "X - Path",DateAdd("d",126,Fields!DOWL.Value),

  DateAdd("d",126,Fields!clockStart.Value) & " - " & DateDiff("d",Fields!clockStart.Value,NOW()))

  The reports runs but the value returned is #Error.

  I know the indervidual parts are correct as tried them indervidually.

  IS there something wrong with structure of my script.

  Thanks in advance

• LoosinMaMind

  Hall of Fame

  Points: 3366

  More actions

  June 21, 2013 at 6:21 am

  #1626295

  sorted, ignore. Thanks