My business is moving all our reports from ssrs 2005 to ssrs 2008. I am recycling much of the code such as date and time displays and they are displaying correctly, however much of our reports display the current date and time and the previous code for this is no longer working. The code that is currently used to display the current date and time is below. In our 2005 version reports the date and time will display as dd/mm/yy hh:mm:ss e.g 30/06/11 14:36:21 however when this code is placed in the 2008 version report it is displaying as m/dd/yy and an unrecognized time format. The year is also showing as 21 instead of 11. ="As at " & Left(CStr(Now()),2) & MID(CStr(Now()),3,4) & MID(CStr(Now()),9,2) & " " & Right(Now(),8)

I suppose the language settings of your report has been changed. Please check to have the proper language settings for "en-NZ" the date is displayed in required format. To avoid this hazzle in future , i recommend to change the expression like ="As at " & day(now()) & "/" & Month(now()) & "/" & right(year(now(),2)) & Hour(now()) & ":" & Minute(Now()) & ":" & Second(Now())