Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having a requirement where I need to compare two columns within a table:
FIELD1 | Date |
A | 3/2/16 |
B | 2/5/15 |
I am needing to provide a visual cue such as a a different background color for 'A' if the date for that field is earlier or later than 'B'.
I'm using the following expression:
if(Field1 = 'A', if(Date > Below(Date),Green(),Red()))
however the background color only showing red for me when it should be showing as green
Is there something that I am doing wrong?
try below
if(Field1 = 'A', if(Date > Below(total Date),Green(),Red()))
Yes, that worked. Thanks!
I had forgotten to mention that the they were also wanting grey color if the dates are the same.
What would the expression be?
add one more if in it try below
if(Field1 = 'A', if(Date > Below(total Date),Green(),if(Date<Below(total Date),Red(),grey())))
Regards,
Hi I tried that, seems that I am still seeing the text turn green when the dates are the same