Issue coloring a bar chart

[ShellyG]

Dear all,

I have an issue with coloring a simple bar chart. I am using the following expression for the coloring: 

=if(date(PROMISE_DATE, 'DD-MM-YYYY')<date(today(), 'DD-MM-YYYY'), rgb(0,128,0)
,if(date(PROMISE_DATE, 'DD-MM-YYYY')=date(today(), 'DD-MM-YYYY'), rgb(0,0,128)
,if(date(PROMISE_DATE, 'DD-MM-YYYY')>date(today(), 'DD-MM-YYYY'), rgb(0,255,0))))

I tested in a table object and it assigned the colors properly. When I attempt to use the same expression in the bar chart -> under Appearance -> Colors and Legend -> Expression, it just doesn't work. 

Any ideas why this might be happening? 

Thanks in advance! 

BR, 

Shelly