Comparing two columns in table

[aswinnar]

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?

[Kushal_Chawda]

try below

if(Field1 = 'A', if(Date > Below(total Date),Green(),Red()))

[aswinnar]

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? 

[PrashantSangle]

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,

[aswinnar]

Hi I tried that, seems that I am still seeing the text turn green when the dates are the same