When a reference is used in a form its possible to set its Item Rules to display each row differently. It doesn't appear to be possible to use functions in these rules. They seem to want just very simple expressions based only on the object whose instanes are beeing displayed.
What is the set of restrictions for item rules?
For example, I'd like to be able to change the colour on Task items whose due dates are 3 days before today to yellow and on those that are 7 days overdue to red. That means I'd need to be able to use an expression that included a Task timestamp field, a value from SystemSettings and the CURRENT_DATE function.
Also, is a similar functionality available for query results? So far it seems not.
It would be nice to be able to do the same thing for the results of a query.
thanks,
Terry