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 |
|
Les.61
Starting Member
49 Posts |
 Posted - 2010-03-04 : 00:07:43
|
I am trying to highlight any fields where the date has past and use the following in Properties - Textbox - Background Colour.=iif(Fields!OverdraftLimitExpiryDate.Value < today(),"red","transparent")This works fine but if the account does not have a date it also records in RED.How do I get it to only colour if there is a date and not colour if there is no date?  |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-03-04 : 07:19:07
|
| put in an "and" condition of "and expirydate is not blank".am not familiar with the syntax....but have a go and post any efforts if stuck. |
 |
|
|
Les.61
Starting Member
49 Posts |
Posted - 2010-03-04 : 19:24:35
|
| Managed to solve the problem=iif(Fields!OverdraftLimitExpiryDate.Value Is Nothing,"transparent",iif(Fields!OverdraftLimitExpiryDate.Value < today (),"red","LightGreen")) |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-03-05 : 07:34:03
|
| Aha....Excel style formula. |
|
|
|
|
|
|
Colour Formatting for Blank