Home Forums SQL Server 2008 SQL Server 2008 - General =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1) Errors, but does not give me an error code RE: =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1) Errors, but does not give me an error code

  • January 7, 2013 at 12:43 pm

    #1574487

    Gillian_Pappas2002 (1/7/2013)

    =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1)

    gives me "Error" on output, but there are no error codes. The syntax checks out and the values for

    fields urgency_level and DateDifference are numeric data.

    obviously it errors with your posted query .. need more info and full query you are trying and I see IIF what is it ? do you mean IF

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]