I guess the problem is in the espression This is the expression in for date which id DD/MM/YY =cdate(iif(day(dateadd("d",-1,now()))<10,"0"&day(dateadd("d",-1,now())),day(dateadd("d",-1,now())))&"/"&iif(month(dateadd("d",-1,now()))<10,"0"&month(dateadd("d",-1,now())),month(dateadd("d",-1,now())))&"/"&year(dateadd("d",-1,now())))--> date which should mm/dd/yy, can you help mePachi

Hi All, I am getting the below error in my BIDS Environment , could you please advice, An error occurred during local report processing The default value expression for report parameter 'date contains errot:'conversion from string "27/06/2012" to type 'Date' is not vaild Regards, Pachi Pachi

Check your regional settings for your system and the locale settings for the report. Also, how do you enter the date 27/06/2012. Is it something you entered as a parameter? If yes, then try and set the parameter type to datetime.The Data Specialist (Blog)

I guess the problem is in the espression This is the expression in for date which id DD/MM/YY =cdate(iif(day(dateadd("d",-1,now()))<10,"0"&day(dateadd("d",-1,now())),day(dateadd("d",-1,now())))&"/"&iif(month(dateadd("d",-1,now()))<10,"0"&month(dateadd("d",-1,now())),month(dateadd("d",-1,now())))&"/"&year(dateadd("d",-1,now())))--> date which should mm/dd/yy, can you help mePachi

I advise you use DateSerial rather than build a string and convert it into a date.The Data Specialist (Blog)

Hi Pachi, The error occurs because of the "Date and time formats" settings of your operating system. We can adjust the setings by clicking Control Panel-> Clock, Language, and Region-> Region and Language. It seems that the "Short date" is set to a format like "M/d/yyyy". In this way, the "26/07/2012" is invalid for a date format because 26 will be converted to "Month" during the convertion. To avoid the issue, you can adjust your expression to exchange the orders of Day and Month. Besides, you can also change the Format language to "English (United Kingdom)" or change the "Short Date" format to "dd/MM/yyyy". Actually, to achieve your goal, you can use an expression that is much simpler: =FormatDateTime(DateAdd("d",-1,Now()), "dd/MM/yyyy") If you have any questions, please feel free to let me know. Regards, Mike Yin