HOW DO I IMPLEMENT THIS IN SSRS IF ( isnull({RPT_CLINIC_LIST.SCHEDULE_DATE} )) Then IF ( isnull({@scheduleDate} )) Then IF (Time(CurrentDateTime) > Time("12:00") ) Then DateAdd("d", 1, CurrentDate) ELSE CurrentDate ELSE {@scheduleDate} ELSE {RPT_CLINIC_LIST.SCHEDULE_DATE} Plz mark as Answer if your problem is resolved. Reddy

This can be done with IIF statement in SSRS. here is sample : Use multiple IIF functions (also known as "nested IIFs") to return one of three values depending on the value of PctComplete. The following expression can be placed in the fill color of a text box to change the background color depending on the value in the text box. =IIF(Fields!PctComplete.Value >= 10, "Green", IIF(Fields!PctComplete.Value >= 1, "Blue", "Red")) in your case some thing like this IIF (({RPT_CLINIC_LIST.SCHEDULE_DATE}) <>"" ,IIF ({@scheduleDate}) <>"" ,IIF (Time(CurrentDateTime) > Time("12:00") , DateAdd("d", 1, CurrentDate) , CurrentDate ) , {@scheduleDate} ) , {RPT_CLINIC_LIST.SCHEDULE_DATE} ) http://uk.linkedin.com/in/ramjaddu

I am getting wrong no.of argumentsPlz mark as Answer if your problem is resolved. Reddy