| Author |
 Topic  |
|
|
sz1
Constraint Violating Yak Guru
United Kingdom
294 Posts |
 Posted - 03/06/2013 : 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!
SZ1
Learning and development is the driving force in the universe...! |
|
|
sz1
Constraint Violating Yak Guru
United Kingdom
294 Posts |
Posted - 03/06/2013 : 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")
SZ1
Learning and development is the driving force in the universe...! |
 |
|
| |
Topic |
|
|
|
Switch Colour
