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 |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2007-11-23 : 05:16:02
|
| hu guys,I am trying to change the colour of the background of each row in a table depending on the month it is.I have tried putting the expression =IIF(Datepart("month",Fields!AppDate.Value) = Datepart("month",Now) ,"Green","Red")in the backgroundcolor forthe table row, but it doesn' work.do you have any suggestions ? or can see why this isn't working?kind regardsJamie |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2007-11-23 : 06:18:22
|
| Replace "month" with "m"=IIF(Datepart("m",Fields!AppDate.Value) = Datepart("m",Now) ,"Green","Red") |
 |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-11-23 : 10:00:25
|
| cheers.can't beleive that all it was ! |
|
|
|
|
|
|
conditional formatting