what is wrong in this statement? =IIF(Fields!PROPERTYID.Value = "DIECHNGE1 E,DIECHNGE2 E,DIECHNGE3 E" ,DateAdd("D",10,Fields!TRANSDATE.Value), IIF(Fields!PROPERTYID.Value = "DIECHNGE1,DIECHNGE2,DIECHNGE3" ,DateAdd("D",15,Fields!TRANSDATE.Value),IIF (Fields!PROPERTYID.Value = "PM",Fields!TRANSDATE.Value,"NULL")))

Hi Ali, The expression looks ok, what is the issue?Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Hi Ali, Can you post the error?Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Hi alikhan ! You may get the desired output using below expression; =switch( Fields!PROPERTYID.Value = "DIECHNGE1 E,DIECHNGE2 E,DIECHNGE3 E", DateAdd("D",10,Fields!TRANSDATE.Value), Fields!PROPERTYID.Value = "DIECHNGE1,DIECHNGE2,DIECHNGE3" , DateAdd("D",15,Fields!TRANSDATE.Value), Fields!PROPERTYID.Value = "PM", Fields!TRANSDATE.Value, Fields!PROPERTYID.Value IS NOTHING, "NULL" ) You can alternatively use switch statement as shown above. Please let me know if this helps. Hopefully i have answered you correctly. Thanks, Hasham

Hi There Thanks for your posting. Can you please try this expression =IIF(Fields!PROPERTYID.Value = "DIECHNGE1 E,DIECHNGE2 E,DIECHNGE3 E" ,DateAdd("D",10,Fields!TRANSDATE.Value), IIF(Fields!PROPERTYID.Value = "DIECHNGE1,DIECHNGE2,DIECHNGE3" ,DateAdd("D",15,Fields!TRANSDATE.Value),IIF (Fields!PROPERTYID.Value = "PM",Fields!TRANSDATE.Value,Nothing))) =IIF(Fields!PROPERTYID.Value = "DIECHNGE1 E,DIECHNGE2 E,DIECHNGE3 E" ,DateAdd("D",10,Fields!TRANSDATE.Value), IIF(Fields!PROPERTYID.Value = "DIECHNGE1,DIECHNGE2,DIECHNGE3" ,DateAdd("D",15,Fields!TRANSDATE.Value),IIF (Fields!PROPERTYID.Value = "PM",Fields!TRANSDATE.Value,Nothing))) Many thanks Syed Qazafi Anjum