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
Gillian_Pappas2002
SSCommitted
Points: 1714
More actions
January 7, 2013 at 2:40 pm
#1574536
Thanks for your help......I got it to work....
=IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2 and Fields!KeptAppointments.Value = 1, 1,0)