Color Coding a Row in Alteryx Table based on Expression

[RCern]

Hi there.

I am pulling data out of a database and placing it into an Alteryx Table.  I am trying to automate color coding a row in the table if the date in the row falls between two specific dates.  In the table configuration, I entered a formula in the Rule row but it is not working.  None of the rows that meet the criteria are being colored.  Am I writing the expression wrong?  Please see the screenshot.  I don't have the ability to post the workflow since it contains a database connection.

[ddala]

It sounds like the formula you’re using in the Rule row might not be quite right. To color code rows based on a date range, ensure that the formula correctly compares the date in the row with your specific date range. fire kirin 777

[binuacs · Accepted solution]

@RCern your formula should work, make sure that the EffectiveDate field is a date data type