Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
 Posted - 2012-08-16 : 01:56:38
|
| Hi Guys,Whats wrong with this codes. i have an error.my date parameter value is :2012/05/01=MonthName(Month(DateAdd("M",-5,Parameters!StartDate.Value)))&" "& Datepart("Y",DATEADD("MM",DATEDIFF("MM",-0,Parameters!StartDate.Value)- 6,0)this code the result should be December 2011, i have en error to get the year. |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2012-08-16 : 02:24:02
|
| I got It now.=MonthName(Month(DateAdd("M",-5,Parameters!StartDate.Value)))&" "& Year(DateAdd("M",-5,Parameters!StartDate.Value)) |
 |
|
|
|
|
|
expression Error