I'm getting the error rsRuntimeErrorInExpression "Argument "Interval" is not a valid value. I used the same expression in RS 2005 and I never got this error message. what can I do to fix it? =FORMAT(switch(Fields!TimeToRespond.Value = 1,DATEADD( "d", 60, Fields!Accepted_Date.Value) ,Fields!TimeToRespond.Value = 2, DATEADD("d", 90, Fields!Accepted_Date.Value),Fields!TimeToRespond.Value = 3, DATEADD("d", 150, Fields!Accepted_Date.Value),Fields!TimeToRespond.Value = 4, NOTHING,true,Fields!TimeToRespond.Value),"MM/dd/yy") Angie

Hi sunnyplace, Based on your description, I performed a test on my test environment. The expression above worked fine in my report. In your case, this issue might be caused by other wrong expression in your report. I suggest you that create a new report and then test the expressions individually. There is a related thread about this error message, please see: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3c81593d-1b39-40ea-beda-b58e2af99135/ Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Bin Long TechNet Community Support