Visual Cue Expression not working?

[#1]

Hello All -

I am attempting to use the following expression for highlighting data in my straight table:

=date(monthend(USInventory_promise_date)-6)

The column that this is being applied to is a date column (Prom Date).

I am not getting the data highlighted as I would have expected. 

Ultimately what this should do is highlight anything that has a Prom Date in the last 7 days of the month.

To test my expression, I added a calculated dimension to my chart, which shows that the expression is calculating the desired date (screen shot below - right column - Expression Date Test).

I would have expected the highlighted items in my screen shot below to have been picked up by that expression(above) in the visual Cues "Upper".

Interpreting the first row of data;

The way I am reading it would be If the Promise Date is >= 6/24/12 then highlight.

If I hard code the date in the expression (simply put =date('6/24/12') the highlighting works as expected.

Is there some fine point I am missing with date compares in expressions used for visual cues?

[#2 · Accepted solution]

Instead of visual cues, try putting it in Chart Properties > Background Color:

[#3]

Excellent suggestion.  I have not used Background colors before, as I am relatively new to all this.

Is there a known shortfall of the visual cues that they would not provide the same results?  Is background color the preferred solution?

Many thanks for the answer!

[#4]

I prefer Background Colors, since it offers more flexibility.  Visual cues are good for numeric data, but don't seem to handle date fields very well. Anything you can do in Visual Cues, you can do in Background colors, but ultimately I think it is just personal preference.