How can I define a state where the condition compares to a dynamic date value? For example, I want to color all the dates older than two days ago.
Set up states based on dates
Prior to Dundas BI version 4, you would have to use a calculated element in the data cube and return something like (DateTime.Today.AddDays (-2)), which you can then use in your state condition.
As of Dundas BI version 4, you can create a formula measure, which you can create more easily and use in your state condition. For your example, you can use the formula ($OrderDate$.MemberTime - DateTime.Today).Days to calculate the difference in days and then apply the state condition to it.