|
02119
Starting Member
8 Posts |
 Posted - 01/18/2013 : 07:06:45
|
Hi,
I have a table displaying dates from 2 different datasets, this works great
but I need the backround of the columns to change depending on the date value. This is my query
=IIF(DateDiff("d", Lookup(Fields!BrigID.Value,Fields!BrigID.Value,Fields!flddDRIVTrainDate.Value, "Base1Shared"), Now())>1095,"Red","no color")
So if the date value is more than 3 years old from when the report is run the backround goes red and I know that one of the staff needs to complete a course.
The trouble is that this code works but also seems to remove the text colour as well
Any help would be greatful |
|
Backround Colour based on Lookup value help
