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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Switch Colour

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!


SZ1
Learning 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")

SZ1
Learning and development is the driving force in the universe...!
Go to Top of Page
   

- Advertisement -