Hello, I have the folloiwing on tablix1 Expression = =CDate(IIF(Fields!SCOMDate.Value is nothing,IIF(Fields!IPDate.Value is nothing,IIF(Fields!HPSIMDate.Value is nothing,IIF(Fields!DCWalk_Date.Value is nothing,IIF(Fields!FCSDate.Value is nothing,IIF(Fields!Legato_Date.Value is nothing,IIF(Fields!DPMDate.Value is nothing,IIF(Fields!Veeam_Date.Value is nothing,IIF(Fields!Ex_DBDate.Value is nothing,IIF(Fields!Ex_User_DBDate.Value is nothing,IIF(Fields!PWScript_Date.Value is nothing,IIF(Fields!SCCMDate.Value is nothing,IIF(Fields!Storage_Date.Value is nothing, Fields!Storage_Date.Value, Fields!Storage_Date.Value),Fields!SCCMDate.Value),Fields!PWScript_Date.Value),Fields!Ex_User_DBDate.Value),Fields!Ex_DBDate.Value),Fields!Veeam_Date.Value),Fields!DPMDate.Value),Fields!Legato_Date.Value),Fields!FCSDate.Value),Fields!DCWalk_Date.Value),Fields!HPSIMDate.Value),Fields!IPDate.Value),Fields!SCOMDate.Value)) TEXT OPERATOR: > Value = =DateAdd(Day(CDate(Fields!Date_Result.Value)),-1*Weekday(Today()),Today()) Error 1 [rsCompilerErrorInExpression] The FilterValue expression for the tablix table1 contains an error: [BC30519] Overload resolution failed because no accessible 'DateAdd' can be called without a narrowing conversion: C:\Users\dominiqued\Documents\Visual Studio 2008\Projects\Report Project1\Report Project1\Report on Daily Maintenance Tasks-Weekly.rdl 0 0 ThanksDom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Hi, I can see one issue with your Dateadd() method. Give a try to following expression and give more details about the use of weekday() method in your expression. =DateAdd("d",Day(CDate(Fields!Date_Result.Value)),Today()) Please refer this link for syntax of the dateadd method http://msdn.microsoft.com/en-us/library/aa337194(v=sql.90).aspxAftab Ansari

Hello, I am not sure this will give me what I need, the report to be limited to the last 7 days... (-1*WeekDay(Today)), is it possible? This formula applied in the Tablix > Filter is giving me the same result as before no fileter at all... Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager