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 |
|
sz1
Aged Yak Warrior
555 Posts |
 Posted - 2013-03-06 : 09:08:17
|
| Anyone know why this wont change my red colour, all other ok?=Switch(Fields!Agreed_Solved_Date___Time.Value = DateAdd("d",0, Today()),"Red",Fields!Agreed_Solved_Date___Time.Value >= DateAdd("d",+1, Today()),"Green",Fields!Agreed_Solved_Date___Time.Value <=DateAdd("d",0, Today()),"Blue",Len(Fields!Agreed_Solved_Date___Time.Value) = 0,"")The Agreed_Solved_Date_Time field for todays tickets which there are 6 are staying black even though they are showing todays date?Thanks in advance!SZ1Learning and development is the driving force in the universe...! |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2013-03-06 : 09:38:59
|
| This seemed to work:=Switch(Fields!Agreed_Solved_Date___Time.Value < Today(),"Blue",Fields!Agreed_Solved_Date___Time.Value <=DateAdd("d",1,Today()),"Red",Fields!Agreed_Solved_Date___Time.Value >=DateAdd("d",0,Today()),"Green")SZ1Learning and development is the driving force in the universe...! |
 |
|
|
|
|
|
|
|
Switch Colour