>>>Here is the code that I thougth would work but doesn't:
>>>
>>>this.column4.DynamicBackColor = 'iif(duedate < DATE(),RGB(255,50,50),this.column4.DynamicBackColor)'
>>
>>I put that code in the Grid.Init, and it seemed to work just fine. Where are you setting it?
>
>Garrett, you are sure that this makes what you tasks make ?
Well, I set the Column.BackColor to green, and then put the line above (changing it for the actual column name) in the Grid.Init, and browsed a table that had a bunch of different dates. The dates less than today showed up as red: today and later showed up as the correct backcolor.
This also works, and semantically makes a bit more sense:
this.column1.DynamicBackColor = ;
'iif(duedate < DATE(), ;
RGB(255,50,50), ;
this.column1.BackColor)'