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

  • That is the formula that I added to Visual Studio 2008 calculated formula

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

    Input field Urgency_level can = 1 - 4, and the Field DateDifference can = 0-100, in the above Fx formula

    in Visual Studio I and trying to get the calculated field NeedUrgentDates to be true, if the urgency_level = 2

    and the DateDifference is less than or equal to 2.

    Thanks for your input.